Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Dependent Drop Down List 9

      • busybee_1_in
    2. Replies
      9
      Views
      714
      9
    3. Carim

    1. Drop Down List based on last used row 3

      • busybee_1_in
    2. Replies
      3
      Views
      317
      3
    3. royUK

    1. countifs not counting date values when copied 1

      • bus9892
    2. Replies
      1
      Views
      162
      1
    3. bus9892

    1. Sum a value if its Date is within 90 days of each Month shown in second table 6

      • burdenpi
    2. Replies
      6
      Views
      607
      6
    3. Logit

    1. Identify highest score category within group 3

      • bunty_1244
    2. Replies
      3
      Views
      477
      3
    3. AliGW

    1. Dynamic Named range counting "" in data range 1

      • BScott05
    2. Replies
      1
      Views
      681
      1
    3. skywriter

    1. Extracting long format Month from Today() 1

      • Bryan021
    2. Replies
      1
      Views
      371
      1
    3. Infomage

    1. Countif compound criteria? 3

      • Bryan021
    2. Replies
      3
      Views
      502
      3
    3. NBVC

    1. Erroneous #NAME? error that goes away when I drag the formula back over the cells showing the error 1

      • browncoat
    2. Replies
      1
      Views
      153
      1
    3. royUK

    1. Is it possible to have the user type a formula into a cell and have it treated as text so that other cells can incorporate that into their formula? 8

      • browncoat
    2. Replies
      8
      Views
      338
      8
    3. Carim

    1. AVERAGEIF a range of cells based on a specific value in adjacent cell but ignore empty cells? 6

      • browncoat
    2. Replies
      6
      Views
      870
      6
    3. browncoat

    1. Matching blank cells in SUMIFs with multiple criteria 2

      • browncoat
    2. Replies
      2
      Views
      790
      2
    3. browncoat

    1. xlookup multiple criteria? 2

      • browncoat
    2. Replies
      2
      Views
      1.8k
      2
    3. gyankosh.net

    1. Complicated Ranking based off of multiple conditions 8

      • broman5000
    2. Replies
      8
      Views
      551
      8
    3. broman5000

    1. PROMPTLY. help repair a corrupted Excel file (2003 release version) 1

      • brioche
    2. Replies
      1
      Views
      194
      1
    3. AliGW

    1. Medain if formula not working 3

      • brin1980
    2. Replies
      3
      Views
      589
      3
    3. Fluff13

    1. Extract text from a string of text based on the range defined 13

      • brijeshkeni
    2. Replies
      13
      Views
      806
      13
    3. Carim

    1. formula to return lowest value in a range 1

      • Brent123
    2. Replies
      1
      Views
      164
      1
    3. NBVC

    1. Conditional Formatting Formula 2

      • brandybartz
    2. Replies
      2
      Views
      630
      2
    3. sktneer

    1. Populating multiple cells with drop down 1

      • brando6003
    2. Replies
      1
      Views
      433
      1
    3. NBVC

Display Options