Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
countifs with specific name between two dates 18
- hahsj
-
- Replies
- 18
- Views
- 2.7k
18
-
-
-
-
Last non-empty cell in the column based on three header rows that are criteria 16
- rehan kazi
-
- Replies
- 16
- Views
- 2.6k
16
-
-
-
-
lognormal graph 1
- aeonstorm
-
- Replies
- 1
- Views
- 2.6k
1
-
-
-
-
Index/Match Formula Disappears after Ctrl-Shift-Enter 10
- OldFella
-
- Replies
- 10
- Views
- 2.6k
10
-
-
-
-
Running count of occurrence in list using array formula with spill range 4
- Range Rover
-
- Replies
- 4
- Views
- 2.6k
4
-
-
-
-
Need help with VLOOKUP by WEEKNUM 11
- chobart46
-
- Replies
- 11
- Views
- 2.6k
11
-
-
-
-
Auto populating drop down lists/cells based on conditions 24
- Boycie92
-
- Replies
- 24
- Views
- 2.6k
24
-
-
-
-
TREND Function to Ignore Zeros 7
- msquared99
-
- Replies
- 7
- Views
- 2.5k
7
-
-
-
-
Identify Row Number on Different Sheet to complete COUNTIF on (in single formula) 6
- ruppk825
-
- Replies
- 6
- Views
- 2.5k
6
-
-
-
-
growing range 7
- Eusebious
-
- Replies
- 7
- Views
- 2.5k
7
-
-
-
-
Combine Large and Sumif - Array formula 4
- London.London
-
- Replies
- 4
- Views
- 2.5k
4
-
-
-
-
INDEX MATCH with multiple lookup_arrays/references 12
- B.W.B.
-
- Replies
- 12
- Views
- 2.5k
12
-
-
-
-
Auto Fill Down Number List 11
- luarbiasa
-
- Replies
- 11
- Views
- 2.5k
11
-
-
-
-
Copy data down and across range 24
- jl2509
-
- Replies
- 24
- Views
- 2.5k
24
-
-
-
-
Searchable Dropdown List is working as a normal dropdown list in protected worksheet 8
- MudasGrid
-
- Replies
- 8
- Views
- 2.4k
8
-
-
-
-
Trying to generate actual selling day of current month and current year 6
- dvswindler
-
- Replies
- 6
- Views
- 2.4k
6
-
-
-
-
Sumifs to sum qty's from 3 different columns with same criteria 19
- Freddyfroo
-
- Replies
- 19
- Views
- 2.4k
19
-
-
-
-
Formula find max value for multiple if thens.. between: ">" or "<" and a "," 11
- davex
-
- Replies
- 11
- Views
- 2.4k
11
-
-
-
-
Dynamic way to calculate the last 6 months average. 2
- FaKest
-
- Replies
- 2
- Views
- 2.4k
2
-
-
-
-
Sum numbers in a single cell 7
- chxjett
-
- Replies
- 7
- Views
- 2.4k
7
-