Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Counting unique rows 24

      • schweggen
    2. Replies
      24
      Views
      852
      24
    3. loisdoig

    1. Formula find max value for multiple if thens.. between: ">" or "<" and a "," 11

      • davex
    2. Replies
      11
      Views
      852
      11
    3. KjBox

    1. Countif or Array Formula 3

      • aussiformula
    2. Replies
      3
      Views
      852
      3
    3. crushdrinker06

    1. Give new List including duplicates ignoring zeros 3

      • juriemagic
    2. Replies
      3
      Views
      846
      3
    3. FDibbins

    1. Allocate points from 0-100 based on value 3

      • morsoe
    2. Replies
      3
      Views
      839
      3
    3. crushdrinker06

    1. Hide duplicate running total values. 11

      • Skylane60
    2. Replies
      11
      Views
      837
      11
    3. Skylane60

    1. Sumifs to sum qty's from 3 different columns with same criteria 19

      • Freddyfroo
    2. Replies
      19
      Views
      821
      19
    3. KjBox

    1. Sumproduct with blank criteria 7

      • DaneMark
    2. Replies
      7
      Views
      812
      7
    3. XOR LX

    1. Trying to create formula to exclude any cells that contain the word "D/C" 7

      • Anmari
    2. Replies
      7
      Views
      808
      7
    3. Anmari

    1. Convert time to a usable format in a formula 15

      • jl2509
    2. Replies
      15
      Views
      807
      15
    3. Carim

    1. Formula to replace contents of a cell 8

      • ansridhar
    2. Replies
      8
      Views
      807
      8
    3. ansridhar

    1. define range (C1:C24) with formula 14

      • andrej
    2. Replies
      14
      Views
      802
      14
    3. AliGW

    1. Formulas using the "IF" function. 6

      • Pauli57
    2. Replies
      6
      Views
      802
      6
    3. Pauli57

    1. Concatenate range of column values in a row 4

      • bob22
    2. Replies
      4
      Views
      801
      4
    3. bob22

    1. Auto populating drop down lists/cells based on conditions 24

      • Boycie92
    2. Replies
      24
      Views
      789
      24
    3. AliGW

    1. Color negative percentage red in a text string 5

      • crgannon
    2. Replies
      5
      Views
      788
      5
    3. crushdrinker06

    1. Comparing VLOOKUP speeds versus straight calculations 2

      • MathemAddicts
    2. Replies
      2
      Views
      781
      2
    3. MathemAddicts

    1. Calculating the total commission value from a sliding scale 10

      • 3008300363
    2. Replies
      10
      Views
      779
      10
    3. KjBox

    1. Taken taken minus breaks over midnight 4

      • Static Cat
    2. Replies
      4
      Views
      779
      4
    3. Batman

    1. MODE MATCH Formula (for most common occurance) not considering entire range 13

      • wittonline
    2. Replies
      13
      Views
      778
      13
    3. wittonline

Display Options