Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Lists box 1

      • kennethbrandon
    2. Replies
      1
      Views
      501
      1
    3. royUK

    1. Change values to the right of a decimal point 9

      • jl2509
    2. Replies
      9
      Views
      1.4k
      9
    3. Carim

    1. Trying to get AVE &SUM, considering code in the calcs; not dependent on specific cols 1

      • wittonline
    2. Replies
      1
      Views
      596
      1
    3. wittonline

    1. Extract Records From Different Ranges and Filter Results 3

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

    1. Balance carried forward 2

      • Aussiebuilder
    2. Replies
      2
      Views
      1.7k
      2
    3. KjBox

    1. Index & match 2

      • Aussiebuilder
    2. Replies
      2
      Views
      738
      2
    3. azumi

    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. If & carried forward balances 1

      • Aussiebuilder
    2. Replies
      1
      Views
      514
      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
      515
      1
    3. NBVC

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

      • Dougmeister
    2. Replies
      5
      Views
      735
      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. Countif & min 7

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

    1. Coveryting VB Macro form to Google sheet 1

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

    1. Linking entered dates to column location 1

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

    1. Preserving formula reference to pivot table 5

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

    1. Obtain a string from a formula that contains a link to another workbook 2

      • hugletank
    2. Replies
      2
      Views
      716
      2
    3. hugletank

    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
      907
      7
    3. AliGW

    1. copy 1 cell or another if blank 2

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

Label

Display Options