Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • t0mrogers
    2. Replies
      11
      Views
      239
      11
    3. t0mrogers

    1. Help From KJBox for formula 11

      • Paulbxx
    2. Replies
      11
      Views
      250
      11
    3. Paulbxx

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

      • HestiA
    2. Replies
      11
      Views
      191
      11
    3. Carim

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

      • dmzeigler
    2. Replies
      11
      Views
      202
      11
    3. Carim

    1. Sales table formula 11

      • keyss
    2. Replies
      11
      Views
      210
      11
    3. Carim

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

      • hvargas
    2. Replies
      11
      Views
      230
      11
    3. Carim

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

      • noyb1982
    2. Replies
      11
      Views
      588
      11
    3. JonathanVH

    1. Populate Leave Calendar 11

      • myexcelstar
    2. Replies
      11
      Views
      306
      11
    3. myexcelstar

    1. Non Blanks 11

      • Jazper36
    2. Replies
      11
      Views
      186
      11
    3. NBVC

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

      • wittonline
    2. Replies
      11
      Views
      302
      11
    3. wittonline

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

      • onexc
    2. Replies
      11
      Views
      663
      11
    3. onexc

    1. Select data from a worksheet with specific text 11

      • jl2509
    2. Replies
      11
      Views
      133
      11
    3. Carim

    1. Select data from every (n) columns 11

      • jl2509
    2. Replies
      11
      Views
      158
      11
    3. Carim

    1. Lookup to return 0 instead of blanks 11

      • Peter10
    2. Replies
      11
      Views
      180
      11
    3. AliGW

    1. Return value greater than from multiple rows 11

      • score
    2. Replies
      11
      Views
      418
      11
    3. score

    1. LookUp and return value 11

      • DezB
      • DezB
    2. Replies
      11
      Views
      428
      11
    3. AliGW

    1. Indexing a list in order, based on multiple criteria 11

      • her.rockstar
    2. Replies
      11
      Views
      570
      11
    3. NBVC

    1. Formula find max value for multiple if thens.. between: ">" or "<" and a "," 11

      • davex
    2. Replies
      11
      Views
      852
      11
    3. KjBox

    1. Hide duplicate running total values. 11

      • Skylane60
    2. Replies
      11
      Views
      837
      11
    3. Skylane60

    1. Double counting in SUMPRODUCT formula 11

      • Luis Ah-Hoy Jr.
    2. Replies
      11
      Views
      924
      11
    3. Luis Ah-Hoy Jr.

Display Options