Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. If & carried forward balances 1

      • Aussiebuilder
    3. Replies
      1
      Views
      520
      1

    4. NBVC

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

      • world33
    3. Replies
      3
      Views
      1.1k
      3

    4. Carim

    2. Populating multiple cells with drop down 1

      • brando6003
    3. Replies
      1
      Views
      521
      1

    4. NBVC

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

      • Dougmeister
    3. Replies
      5
      Views
      744
      5

    4. Dougmeister

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

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

    4. BJL

    2. Linking entered dates to column location 1

      • JamesK1993
    3. Replies
      1
      Views
      495
      1

    4. AliGW

    2. Coveryting VB Macro form to Google sheet 1

      • umakanth79in
    3. Replies
      1
      Views
      520
      1

    4. royUK

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

      • wittonline
    3. Replies
      9
      Views
      1.4k
      9

    4. wittonline

    2. Countif & min 7

      • Aussiebuilder
    3. Replies
      7
      Views
      1.1k
      7

    4. Aussiebuilder

    2. Extract Records From Different Ranges and Filter Results 3

      • scratchmaster
    3. Replies
      3
      Views
      943
      3

    4. Krishnakumar

    2. Preserving formula reference to pivot table 5

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

    4. AliGW

    2. copy 1 cell or another if blank 2

      • DJ EXCEL
    3. Replies
      2
      Views
      614
      2

    4. DJ EXCEL

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

      • Exelbeginner
    3. Replies
      3
      Views
      552
      3

    4. AliGW

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

      • 57Frog
    3. Replies
      9
      Views
      1.3k
      9

    4. AliGW

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

      • behemoth87
    3. Replies
      1
      Views
      329
      1

    4. AliGW

    2. Identify highest score category within group 3

      • bunty_1244
    3. Replies
      3
      Views
      587
      3

    4. AliGW

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

      • pbuffh
    3. Replies
      2
      Views
      486
      2

    4. pbuffh

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

      • Sholtan
    3. Replies
      2
      Views
      518
      2

    4. AliGW

Label

Display Options