Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Select data from a worksheet with specific text 11

      • jl2509
    3. Replies
      11
      Views
      611
      11

    4. Carim

    2. Drag down formula and change column names in order 11

      • onexc
    3. Replies
      11
      Views
      3k
      11

    4. onexc

    2. Trouble w VLOOKUP (later in formula) displaying "0"s or #VALUE! 11

      • wittonline
    3. Replies
      11
      Views
      1.6k
      11

    4. wittonline

    2. Non Blanks 11

      • Jazper36
    3. Replies
      11
      Views
      937
      11

    4. NBVC

    2. Populate Leave Calendar 11

      • myexcelstar
    3. Replies
      11
      Views
      1.5k
      11

    4. myexcelstar

    2. Convert pounds and ounces to decimal and other number questions 11

      • noyb1982
    3. Replies
      11
      Views
      4.1k
      11

    4. JonathanVH

    2. Calculation of days from the beginning of the month 11

      • hvargas
    3. Replies
      11
      Views
      841
      11

    4. Carim

    2. Sales table formula 11

      • keyss
    3. Replies
      11
      Views
      1.1k
      11

    4. Carim

    2. Calculating the "initial Investment Value" with CAGR formula and average value 11

      • dmzeigler
    3. Replies
      11
      Views
      868
      11

    4. Carim

    2. Index Match based on Year and Month of data 11

      • HestiA
    3. Replies
      11
      Views
      1.1k
      11

    4. Carim

    2. Help From KJBox for formula 11

      • Paulbxx
    3. Replies
      11
      Views
      1k
      11

    4. Paulbxx

    2. Need help with a formula/VLook up to pull data from a feed sheet 11

      • t0mrogers
    3. Replies
      11
      Views
      1.1k
      11

    4. t0mrogers

    2. DELETE substring of text between text 11

      • DannyGIS
    3. Replies
      11
      Views
      1.2k
      11

    4. DannyGIS

    2. Match Header & a row value to get corresponding value 11

      • kumarsatish
    3. Replies
      11
      Views
      1.2k
      11

    4. Carim

    2. Needing help with matching data in excel 11

      • Roger104
    3. Replies
      11
      Views
      944
      11

    4. Carim

    2. Need help with  VLOOKUP by WEEKNUM 11

      • chobart46
    3. Replies
      11
      Views
      2.4k
      11

    4. Carim

    2. YTD using dynamic spilled array 11

      • MatthewHart
    3. Replies
      11
      Views
      2.2k
      11

    4. AliGW

    2. Need HELP with ARRAY Formula 11

      • cs566
    3. Replies
      11
      Views
      1.8k
      11

    4. cs566

    2. formula - if cell contain specific text then return all values in the list 11

      • Gemma86
    3. Replies
      11
      Views
      1.4k
      11

    4. Fluff13

    2. Use last value in a column, increment it by 1 and start a new column with this value. If value>x, then start the count in this column, from 1 11

      • leema
    3. Replies
      11
      Views
      1.8k
      11

    4. Fluff13

Label

Display Options