Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Improving long nested long HLookup formulas 1
- mexiro
June 4, 2017 at 5:06 PM
- mexiro
June 4, 2017 at 5:19 PM
-
- Replies
- 1
- Views
- 592
1
-
-
-
-
Copy rows of data to another worksheet if a condition is met in one of the cells 1
- Wynnum
June 3, 2017 at 3:51 PM
- Wynnum
June 6, 2017 at 5:06 PM
-
- Replies
- 1
- Views
- 727
1
-
-
-
-
Filtering Array If statement Criteria Help 3
- lize
June 2, 2017 at 5:17 PM
- lize
June 7, 2017 at 3:41 PM
-
- Replies
- 3
- Views
- 809
3
-
-
-
-
SUMPRODUCT over dynamic range - No VBA 1
- al4xms
June 2, 2017 at 9:45 AM
- al4xms
June 2, 2017 at 10:18 AM
-
- Replies
- 1
- Views
- 981
1
-
-
-
-
Indexing a list in order, based on multiple criteria 11
- her.rockstar
June 1, 2017 at 2:21 PM
- her.rockstar
June 1, 2017 at 8:19 PM
-
- Replies
- 11
- Views
- 1.9k
11
-
-
-
-
Conditional Formatting for a Range 7
- onexc
May 31, 2017 at 7:54 PM
- onexc
May 31, 2017 at 9:16 PM
-
- Replies
- 7
- Views
- 1.2k
7
-
-
-
-
Sum based on three criteria, using two named ranges 4
- GlassGal
May 31, 2017 at 7:41 PM
- GlassGal
May 31, 2017 at 9:33 PM
-
- Replies
- 4
- Views
- 670
4
-
-
-
-
Calculate number using index/match based on two criteria 2
- her.rockstar
May 31, 2017 at 5:55 PM
- her.rockstar
May 31, 2017 at 6:54 PM
-
- Replies
- 2
- Views
- 865
2
-
-
-
-
Count ifs last 4 or 5 results 15
- thomascrown
May 31, 2017 at 11:57 AM
- thomascrown
May 31, 2017 at 4:13 PM
-
- Replies
- 15
- Views
- 2k
15
-
-
-
-
Predict next occurrence in digital string 0 or 1 2
- Emphatic
May 29, 2017 at 11:20 AM
- Emphatic
May 29, 2017 at 9:40 PM
-
- Replies
- 2
- Views
- 578
2
-
-
-
-
Excel 2013 Create link in each cell that will find the correct cell on another sheet 2
- MicheleA
May 28, 2017 at 7:03 PM
- MicheleA
January 29, 2018 at 8:44 PM
-
- Replies
- 2
- Views
- 705
2
-
-
-
-
Formula find max value for multiple if thens.. between: ">" or "<" and a "," 11
- davex
May 23, 2017 at 10:28 PM
- davex
May 27, 2017 at 4:12 AM
-
- Replies
- 11
- Views
- 2.7k
11
-
-
-
-
Datevalue Problems 1
- zeninc
May 23, 2017 at 1:27 PM
- zeninc
May 27, 2017 at 5:11 PM
-
- Replies
- 1
- Views
- 601
1
-
-
-
-
Return date of the largest invoice for a salesperson - index match max ... ifs? 1
- imthebus
May 23, 2017 at 11:58 AM
- imthebus
May 23, 2017 at 12:54 PM
-
- Replies
- 1
- Views
- 454
1
-
-
-
-
formula for scale 3
- Marie A.
May 21, 2017 at 7:18 AM
- Marie A.
May 22, 2017 at 12:22 AM
-
- Replies
- 3
- Views
- 796
3
-
-
-
-
Dropdown to populate up to 10 cells at once 1
- vladc
May 19, 2017 at 11:58 PM
- vladc
May 20, 2017 at 3:51 AM
-
- Replies
- 1
- Views
- 459
1
-
-
-
-
Sliding scale in formula for multiple groups 5
- Marie A.
May 19, 2017 at 4:16 AM
- Marie A.
May 19, 2017 at 7:14 PM
-
- Replies
- 5
- Views
- 1k
5
-
-
-
-
Converting Columns to Rows 9
- mattenborough
May 19, 2017 at 12:24 AM
- mattenborough
June 3, 2017 at 4:14 PM
-
- Replies
- 9
- Views
- 1.8k
9
-
-
-
-
2 groups conditional formating 4
- kennethbrandon
May 15, 2017 at 1:55 PM
- kennethbrandon
May 16, 2017 at 2:11 PM
-
- Replies
- 4
- Views
- 1.1k
4
-
-
-
-
Formula showing in cell 3
- mcgee1505
May 15, 2017 at 10:06 AM
- mcgee1505
May 15, 2017 at 9:15 PM
-
- Replies
- 3
- Views
- 761
3
-