Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • wittonline
    3. Replies
      9
      Views
      1.3k
      9

    4. wittonline

    2. Countif & min 7

      • Aussiebuilder
    3. Replies
      7
      Views
      1k
      7

    4. Aussiebuilder

    2. Extract Records From Different Ranges and Filter Results 3

      • scratchmaster
    3. Replies
      3
      Views
      910
      3

    4. Krishnakumar

    2. Preserving formula reference to pivot table 5

      • Melody00
    3. Replies
      5
      Views
      925
      5

    4. KjBox

    2. Match relevant data again 12

      • bob22
    3. Replies
      12
      Views
      1.6k
      12

    4. bob22

    2. match relevant data fields to one id 7

      • bob22
    3. Replies
      7
      Views
      893
      7

    4. AliGW

    2. copy 1 cell or another if blank 2

      • DJ EXCEL
    3. Replies
      2
      Views
      593
      2

    4. DJ EXCEL

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

      • Exelbeginner
    3. Replies
      3
      Views
      513
      3

    4. AliGW

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

      • 57Frog
    3. Replies
      9
      Views
      1.2k
      9

    4. AliGW

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

      • behemoth87
    3. Replies
      1
      Views
      301
      1

    4. AliGW

    2. Identify highest score category within group 3

      • bunty_1244
    3. Replies
      3
      Views
      573
      3

    4. AliGW

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

      • pbuffh
    3. Replies
      2
      Views
      450
      2

    4. pbuffh

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

      • Sholtan
    3. Replies
      2
      Views
      488
      2

    4. AliGW

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

      • bob22
    3. Replies
      5
      Views
      1.7k
      5

    4. Carim

    2. Evaluation Several Conditions 7

      • ksstormhunter
    3. Replies
      7
      Views
      968
      7

    4. rory

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

      • paul789
    3. Replies
      15
      Views
      2.1k
      15

    4. AliGW

    2. Reg change of formula 8

      • Sholtan
    3. Replies
      8
      Views
      866
      8

    4. Sholtan

    2. SUMIF or SUMIFS 4

      • paul789
    3. Replies
      4
      Views
      880
      4

    4. alansidman

    2. Lookup a value 3

      • bogey69
    3. Replies
      3
      Views
      543
      3

    4. bogey69

    2. Circular Reference Erro 5

      • Melody00
    3. Replies
      5
      Views
      846
      5

    4. Melody00

Label

Display Options