Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Counting the frequency of a specific number on a specific day 2

      • M Edwards
    3. Replies
      2
      Views
      849
      2

    4. M Edwards

    2. Comparing VLOOKUP speeds versus straight calculations 2

      • MathemAddicts
    3. Replies
      2
      Views
      1.5k
      2

    4. MathemAddicts

    2. Convert Decimal To Text in Fraction format 1

      • JohnDrew
    3. Replies
      1
      Views
      891
      1

    4. rory

    2. Use Hlookup to find then sum column within specific dates 1

      • merz
      • merz
    3. Replies
      1
      Views
      958
      1

    4. merz

    2. Auto Number +1 from text, if duplicate text not increase 3

      • johnreid7477
    3. Replies
      3
      Views
      1.1k
      3

    4. AliGW

    2. Tips on getting around length limits for formulas? 2

      • ivorykeys87
    3. Replies
      2
      Views
      763
      2

    4. AliGW

    2. move cell values in Description from colums onto the same row based on a key 2

      • Daidin
    3. Replies
      2
      Views
      908
      2

    4. sktneer

    2. Count of unique name and date of birth matches 6

      • QAM
      • QAM
    3. Replies
      6
      Views
      1.7k
      6

    4. QAM

    2. SUMIF Totals based on multiple critertia 7

      • amanda0210
    3. Replies
      7
      Views
      1.3k
      7

    4. amanda0210

    2. SUMIF Using Dynamic Ranges based on text similarities 5

      • endl3ss
    3. Replies
      5
      Views
      1.3k
      5

    4. NBVC

    2. Conditional Formatting Formula 2

      • brandybartz
    3. Replies
      2
      Views
      729
      2

    4. sktneer

    2. Sumproduct with blank criteria 7

      • DaneMark
    3. Replies
      7
      Views
      2.2k
      7

    4. XOR LX

    2. Sum of all values to the right of a selected value in a table. 7

      • jamesharwood
    3. Replies
      7
      Views
      1.3k
      7

    4. sktneer

    2. Find a value in a row and column, return intersecting cell value 6

      • t33p33
    3. Replies
      6
      Views
      1.8k
      6

    4. cytop

    2. percentage difference and if error leave blank 3

      • Gemma86
    3. Replies
      3
      Views
      934
      3

    4. AliGW

    2. COUNTIF Problem 16

      • endl3ss
    3. Replies
      16
      Views
      2.3k
      16

    4. AliGW

    2. Sum the values in one column only unique vauels from another 2

      • vbapadawan
    3. Replies
      2
      Views
      867
      2

    4. vbapadawan

    2. if isnumber search and iserror vlookup index match - used together. 2

      • Emile du Toit
    3. Replies
      2
      Views
      2k
      2

    4. Emile du Toit

    2. Vlookup to subtract values across worksheets 9

      • RobertJ
    3. Replies
      9
      Views
      5.1k
      9

    4. AliGW

    2. Speed of Formulas 4

      • JoshF7
    3. Replies
      4
      Views
      1.2k
      4

    4. JoshF7

Label

Display Options