Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
concatenate text and numbers 6
- lolstre.loster
-
- Replies
- 6
- Views
- 1.5k
6
-
-
-
-
Sumproduct with blank criteria 7
- DaneMark
-
- Replies
- 7
- Views
- 2.1k
7
-
-
-
-
if isnumber search and iserror vlookup index match - used together. 2
- Emile du Toit
-
- Replies
- 2
- Views
- 1.9k
2
-
-
-
-
Vlookup to subtract values across worksheets 9
- RobertJ
-
- Replies
- 9
- Views
- 4.9k
9
-
-
-
-
Sum the values in one column only unique vauels from another 2
- vbapadawan
-
- Replies
- 2
- Views
- 835
2
-
-
-
-
COUNTIF Problem 16
- endl3ss
-
- Replies
- 16
- Views
- 2.2k
16
-
-
-
-
Find a value in a row and column, return intersecting cell value 6
- t33p33
-
- Replies
- 6
- Views
- 1.7k
6
-
-
-
-
percentage difference and if error leave blank 3
- Gemma86
-
- Replies
- 3
- Views
- 878
3
-
-
-
-
Sum of all values to the right of a selected value in a table. 7
- jamesharwood
-
- Replies
- 7
- Views
- 1.2k
7
-
-
-
-
SUMIF Totals based on multiple critertia 7
- amanda0210
-
- Replies
- 7
- Views
- 1.2k
7
-
-
-
-
Conditional Formatting Formula 2
- brandybartz
-
- Replies
- 2
- Views
- 710
2
-
-
-
-
SUMIF Using Dynamic Ranges based on text similarities 5
- endl3ss
-
- Replies
- 5
- Views
- 1.2k
5
-
-
-
-
Count of unique name and date of birth matches 6
- QAM
-
- Replies
- 6
- Views
- 1.5k
6
-
-
-
-
Comparing VLOOKUP speeds versus straight calculations 2
- MathemAddicts
-
- Replies
- 2
- Views
- 1.5k
2
-
-
-
-
move cell values in Description from colums onto the same row based on a key 2
- Daidin
-
- Replies
- 2
- Views
- 872
2
-
-
-
-
Tips on getting around length limits for formulas? 2
- ivorykeys87
-
- Replies
- 2
- Views
- 735
2
-
-
-
-
Auto Number +1 from text, if duplicate text not increase 3
- johnreid7477
-
- Replies
- 3
- Views
- 1.1k
3
-
-
-
-
Use Hlookup to find then sum column within specific dates 1
- merz
-
- Replies
- 1
- Views
- 872
1
-
-
-
-
Convert Decimal To Text in Fraction format 1
- JohnDrew
-
- Replies
- 1
- Views
- 852
1
-
-
-
-
Formulas using the "IF" function. 6
- Pauli57
-
- Replies
- 6
- Views
- 1.4k
6
-