Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Filtering Array If statement Criteria Help 3
- lize
-
- Replies
- 3
- Views
- 734
3
-
-
-
-
SUMPRODUCT over dynamic range - No VBA 1
- al4xms
-
- Replies
- 1
- Views
- 890
1
-
-
-
-
Indexing a list in order, based on multiple criteria 11
- her.rockstar
-
- Replies
- 11
- Views
- 1.7k
11
-
-
-
-
Conditional Formatting for a Range 7
- onexc
-
- Replies
- 7
- Views
- 1k
7
-
-
-
-
Sum based on three criteria, using two named ranges 4
- GlassGal
-
- Replies
- 4
- Views
- 598
4
-
-
-
-
Calculate number using index/match based on two criteria 2
- her.rockstar
-
- Replies
- 2
- Views
- 791
2
-
-
-
-
Count ifs last 4 or 5 results 15
- thomascrown
-
- Replies
- 15
- Views
- 1.8k
15
-
-
-
-
Predict next occurrence in digital string 0 or 1 2
- Emphatic
-
- Replies
- 2
- Views
- 523
2
-
-
-
-
Excel 2013 Create link in each cell that will find the correct cell on another sheet 2
- MicheleA
-
- Replies
- 2
- Views
- 633
2
-
-
-
-
Formula find max value for multiple if thens.. between: ">" or "<" and a "," 11
- davex
-
- Replies
- 11
- Views
- 2.4k
11
-
-
-
-
Datevalue Problems 1
- zeninc
-
- Replies
- 1
- Views
- 532
1
-
-
-
-
Return date of the largest invoice for a salesperson - index match max ... ifs? 1
- imthebus
-
- Replies
- 1
- Views
- 413
1
-
-
-
-
formula for scale 3
- Marie A.
-
- Replies
- 3
- Views
- 690
3
-
-
-
-
Dropdown to populate up to 10 cells at once 1
- vladc
-
- Replies
- 1
- Views
- 395
1
-
-
-
-
Sliding scale in formula for multiple groups 5
- Marie A.
-
- Replies
- 5
- Views
- 875
5
-
-
-
-
Converting Columns to Rows 9
- mattenborough
-
- Replies
- 9
- Views
- 1.6k
9
-
-
-
-
2 groups conditional formating 4
- kennethbrandon
-
- Replies
- 4
- Views
- 970
4
-
-
-
-
Formula showing in cell 3
- mcgee1505
-
- Replies
- 3
- Views
- 668
3
-
-
-
-
Trying to extract data meeting 3 conditions 8
- Amitouj
-
- Replies
- 8
- Views
- 1k
8
-
-
-
-
Hide duplicate running total values. 11
- Skylane60
-
- Replies
- 11
- Views
- 2.9k
11
-