Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. If & carried forward balances 1

      • Aussiebuilder
    2. Replies
      1
      Views
      520
      1
    3. NBVC

    1. formula to remove all characters after a dash in a text string from the right 3

      • world33
    2. Replies
      3
      Views
      1.1k
      3
    3. Carim

    1. Populating multiple cells with drop down 1

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

    1. Parse cell for 1 of 3 values, return corresponding string value 5

      • Dougmeister
    2. Replies
      5
      Views
      744
      5
    3. Dougmeister

    1. When G matches B, count the number of values in C (that do not match H) 5

      • BJL
      • BJL
    2. Replies
      5
      Views
      1k
      5
    3. BJL

    1. Linking entered dates to column location 1

      • JamesK1993
    2. Replies
      1
      Views
      495
      1
    3. AliGW

    1. Coveryting VB Macro form to Google sheet 1

      • umakanth79in
    2. Replies
      1
      Views
      520
      1
    3. royUK

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

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

    1. Countif & min 7

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

    1. Extract Records From Different Ranges and Filter Results 3

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

    1. Preserving formula reference to pivot table 5

      • Melody00
    2. Replies
      5
      Views
      987
      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
      913
      7
    3. AliGW

    1. copy 1 cell or another if blank 2

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

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

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

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

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

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

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

    1. Identify highest score category within group 3

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

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

      • pbuffh
    2. Replies
      2
      Views
      486
      2
    3. pbuffh

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

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

Label

Display Options