Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Trying to understand cell formulas when extra characters used, learn to SUM and AVE 9

      • wittonline
    2. Replies
      9
      Views
      1.3k
      9
    3. wittonline

    1. Countif & min 7

      • Aussiebuilder
    2. Replies
      7
      Views
      1k
      7
    3. Aussiebuilder

    1. Extract Records From Different Ranges and Filter Results 3

      • scratchmaster
    2. Replies
      3
      Views
      910
      3
    3. Krishnakumar

    1. Preserving formula reference to pivot table 5

      • Melody00
    2. Replies
      5
      Views
      925
      5
    3. KjBox

    1. Match relevant data again 12

      • bob22
    2. Replies
      12
      Views
      1.6k
      12
    3. bob22

    1. match relevant data fields to one id 7

      • bob22
    2. Replies
      7
      Views
      893
      7
    3. AliGW

    1. copy 1 cell or another if blank 2

      • DJ EXCEL
    2. Replies
      2
      Views
      593
      2
    3. DJ EXCEL

    1. Reduce list of dates by selecting earliest and latest date 3

      • Exelbeginner
    2. Replies
      3
      Views
      513
      3
    3. AliGW

    1. formula to compare a complete row to find "yes" "no" or blank 9

      • 57Frog
    2. Replies
      9
      Views
      1.2k
      9
    3. AliGW

    1. From four billing rates (depending on two separate types of inputs), formula to pick1 1

      • behemoth87
    2. Replies
      1
      Views
      301
      1
    3. AliGW

    1. Identify highest score category within group 3

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

    1. Select And Replicate A Named Range Based On A Cell Value 2

      • pbuffh
    2. Replies
      2
      Views
      450
      2
    3. pbuffh

    1. formula to compare a complete row to other row finding duplicates row 2

      • Sholtan
    2. Replies
      2
      Views
      488
      2
    3. AliGW

    1. Variable columns possible in Sumproduct (vlookup) formula 5

      • bob22
    2. Replies
      5
      Views
      1.7k
      5
    3. Carim

    1. Evaluation Several Conditions 7

      • ksstormhunter
    2. Replies
      7
      Views
      968
      7
    3. rory

    1. Highlight largest value cell in range based on other columns 15

      • paul789
    2. Replies
      15
      Views
      2.1k
      15
    3. AliGW

    1. Reg change of formula 8

      • Sholtan
    2. Replies
      8
      Views
      866
      8
    3. Sholtan

    1. SUMIF or SUMIFS 4

      • paul789
    2. Replies
      4
      Views
      880
      4
    3. alansidman

    1. Lookup a value 3

      • bogey69
    2. Replies
      3
      Views
      543
      3
    3. bogey69

    1. Circular Reference Erro 5

      • Melody00
    2. Replies
      5
      Views
      846
      5
    3. Melody00

Label

Display Options