Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

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

      • ivorykeys87
    3. Replies
      2
      Views
      771
      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
      918
      2

    4. sktneer

    2. Comparing VLOOKUP speeds versus straight calculations 2

      • MathemAddicts
    3. Replies
      2
      Views
      1.5k
      2

    4. MathemAddicts

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

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

    4. QAM

    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
      743
      2

    4. sktneer

    2. SUMIF Totals based on multiple critertia 7

      • amanda0210
    3. Replies
      7
      Views
      1.3k
      7

    4. amanda0210

    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. percentage difference and if error leave blank 3

      • Gemma86
    3. Replies
      3
      Views
      954
      3

    4. AliGW

    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. 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
      873
      2

    4. vbapadawan

    2. Vlookup to subtract values across worksheets 9

      • RobertJ
    3. Replies
      9
      Views
      5.2k
      9

    4. AliGW

    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. Sumproduct with blank criteria 7

      • DaneMark
    3. Replies
      7
      Views
      2.2k
      7

    4. XOR LX

    2. concatenate text and numbers 6

      • lolstre.loster
    3. Replies
      6
      Views
      1.6k
      6

    4. AliGW

    2. Speed of Formulas 4

      • JoshF7
    3. Replies
      4
      Views
      1.2k
      4

    4. JoshF7

    2. Dynamic Range -start with specific cell content 1

      • Feedoffice1
    3. Replies
      1
      Views
      635
      1

    4. AliGW

    2. Adding additional fomulas to existing links from multiple sources 2

      • diez
      • diez
    3. Replies
      2
      Views
      974
      2

    4. Green Crocodile

    2. How to ignore columns using offset formula? (Moving reference cell) 1

      • Nickexcel22
    3. Replies
      1
      Views
      1.1k
      1

    4. Green Crocodile

Label

Display Options