Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. If error 2

      • Stephen Bennett
    3. Replies
      2
      Views
      421
      2

    4. Stephen Bennett

    2. Get Column Number in a given range 1

      • luzmen
    3. Replies
      1
      Views
      421
      1

    4. luzmen

    2. Workdays in the Month formula? [SOLVED] 1

      • Johnnyv015
    3. Replies
      1
      Views
      420
      1

    4. Johnnyv015

    2. Returning Data if Two matches are made 1

      • chelly
    3. Replies
      1
      Views
      419
      1

    4. chelly

    2. Formula I got for 1 cell drop down I can't tweaked for another cell drop down 1

      • PaulaD
    3. Replies
      1
      Views
      418
      1

    4. Carim

    2. Offset incremental row increase away from anchor row 2

      • dsohng
    3. Replies
      2
      Views
      417
      2

    4. dsohng

    2. Tiered Incentive Calculation 1

      • natrajc
    3. Replies
      1
      Views
      417
      1

    4. natrajc

    2. Formula to apply conditional formatting to highlight specific cells based the cell to the left

      • CapG
      • CapG
    3. Replies
      0
      Views
      416

    2. Return Text Before Nth Instance of Particular Character 2

      • thenoodly1
    3. Replies
      2
      Views
      416
      2

    4. thenoodly1

    2. check date criteria and match 3

      • timzy
    3. Replies
      3
      Views
      416
      3

    4. timzy

    2. Excel Solver: trying to construct a table for staffs allocation 2

      • Keatnuxsuo
    3. Replies
      2
      Views
      416
      2

    4. Keatnuxsuo

    2. sum(sumifs... 2

      • akbarnikain
    3. Replies
      2
      Views
      415
      2

    4. akbarnikain

    2. Rank formula is providing different rank for the same number 2

      • mbkupfer
    3. Replies
      2
      Views
      415
      2

    4. mbkupfer

    2. Return date of the largest invoice for a salesperson - index match max ... ifs? 1

      • imthebus
    3. Replies
      1
      Views
      415
      1

    4. Carim

    2. INDEX MATCH of Two Lookup_Array 1

      • IEXCELMYWORK
    3. Replies
      1
      Views
      414
      1

    4. Carim

    2. Vlook up an amount for an item and deduct it from that row - issue is that items repeat multiple times - need to take into account the amount already deducted from the same item in the above rows 1

      • jpetraityte
    3. Replies
      1
      Views
      412
      1

    4. Estevaoba

    2. VLookup Help.... 1

      • Rededdie
    3. Replies
      1
      Views
      412
      1

    4. Carim

    2. identify exceptions when comparing two files 1

      • Jon_P
    3. Replies
      1
      Views
      412
      1

    4. AliGW

    2. I hope someone's here would aid me 2

      • TinaNicol
    3. Replies
      2
      Views
      410
      2

    4. AlborzSidi

    2. How to identify leaders? 9

      • GradB
    3. Replies
      9
      Views
      409
      9

    4. Carim

Label

Display Options