Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. If error 2

      • Stephen Bennett
    2. Replies
      2
      Views
      421
      2
    3. Stephen Bennett

    1. Get Column Number in a given range 1

      • luzmen
    2. Replies
      1
      Views
      421
      1
    3. luzmen

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

      • Johnnyv015
    2. Replies
      1
      Views
      420
      1
    3. Johnnyv015

    1. Returning Data if Two matches are made 1

      • chelly
    2. Replies
      1
      Views
      419
      1
    3. chelly

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

      • PaulaD
    2. Replies
      1
      Views
      418
      1
    3. Carim

    1. Offset incremental row increase away from anchor row 2

      • dsohng
    2. Replies
      2
      Views
      417
      2
    3. dsohng

    1. Tiered Incentive Calculation 1

      • natrajc
    2. Replies
      1
      Views
      417
      1
    3. natrajc

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

      • CapG
      • CapG
    2. Replies
      0
      Views
      416
    1. Return Text Before Nth Instance of Particular Character 2

      • thenoodly1
    2. Replies
      2
      Views
      416
      2
    3. thenoodly1

    1. check date criteria and match 3

      • timzy
    2. Replies
      3
      Views
      416
      3
    3. timzy

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

      • Keatnuxsuo
    2. Replies
      2
      Views
      416
      2
    3. Keatnuxsuo

    1. sum(sumifs... 2

      • akbarnikain
    2. Replies
      2
      Views
      415
      2
    3. akbarnikain

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

      • mbkupfer
    2. Replies
      2
      Views
      415
      2
    3. mbkupfer

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

      • imthebus
    2. Replies
      1
      Views
      415
      1
    3. Carim

    1. INDEX MATCH of Two Lookup_Array 1

      • IEXCELMYWORK
    2. Replies
      1
      Views
      414
      1
    3. Carim

    1. 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
    2. Replies
      1
      Views
      412
      1
    3. Estevaoba

    1. VLookup Help.... 1

      • Rededdie
    2. Replies
      1
      Views
      412
      1
    3. Carim

    1. identify exceptions when comparing two files 1

      • Jon_P
    2. Replies
      1
      Views
      412
      1
    3. AliGW

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

      • TinaNicol
    2. Replies
      2
      Views
      410
      2
    3. AlborzSidi

    1. How to identify leaders? 9

      • GradB
    2. Replies
      9
      Views
      409
      9
    3. Carim

Label

Display Options