Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Trying to understand cell formulas when extra characters used, learn to SUM and AVE 9
- wittonline
-
- Replies
- 9
- Views
- 1.3k
9
-
-
-
-
Countif & min 7
- Aussiebuilder
-
- Replies
- 7
- Views
- 1k
7
-
-
-
-
Extract Records From Different Ranges and Filter Results 3
- scratchmaster
-
- Replies
- 3
- Views
- 910
3
-
-
-
-
Preserving formula reference to pivot table 5
- Melody00
-
- Replies
- 5
- Views
- 925
5
-
-
-
-
Match relevant data again 12
- bob22
-
- Replies
- 12
- Views
- 1.6k
12
-
-
-
-
match relevant data fields to one id 7
- bob22
-
- Replies
- 7
- Views
- 893
7
-
-
-
-
copy 1 cell or another if blank 2
- DJ EXCEL
-
- Replies
- 2
- Views
- 593
2
-
-
-
-
Reduce list of dates by selecting earliest and latest date 3
- Exelbeginner
-
- Replies
- 3
- Views
- 513
3
-
-
-
-
formula to compare a complete row to find "yes" "no" or blank 9
- 57Frog
-
- Replies
- 9
- Views
- 1.2k
9
-
-
-
-
From four billing rates (depending on two separate types of inputs), formula to pick1 1
- behemoth87
-
- Replies
- 1
- Views
- 301
1
-
-
-
-
Identify highest score category within group 3
- bunty_1244
-
- Replies
- 3
- Views
- 573
3
-
-
-
-
Select And Replicate A Named Range Based On A Cell Value 2
- pbuffh
-
- Replies
- 2
- Views
- 450
2
-
-
-
-
formula to compare a complete row to other row finding duplicates row 2
- Sholtan
-
- Replies
- 2
- Views
- 488
2
-
-
-
-
Variable columns possible in Sumproduct (vlookup) formula 5
- bob22
-
- Replies
- 5
- Views
- 1.7k
5
-
-
-
-
Evaluation Several Conditions 7
- ksstormhunter
-
- Replies
- 7
- Views
- 968
7
-
-
-
-
Highlight largest value cell in range based on other columns 15
- paul789
-
- Replies
- 15
- Views
- 2.1k
15
-
-
-
-
Reg change of formula 8
- Sholtan
-
- Replies
- 8
- Views
- 866
8
-
-
-
-
SUMIF or SUMIFS 4
- paul789
-
- Replies
- 4
- Views
- 880
4
-
-
-
-
Lookup a value 3
- bogey69
-
- Replies
- 3
- Views
- 543
3
-
-
-
-
Circular Reference Erro 5
- Melody00
-
- Replies
- 5
- Views
- 846
5
-