Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Use COUNTIF on column that contains TRIM formula 3
- paul789
-
- Replies
- 3
- Views
- 2.2k
3
-
-
-
-
COUNTIF Problem 16
- endl3ss
-
- Replies
- 16
- Views
- 2.2k
16
-
-
-
-
Sum non-consecutive/contiguous cells by Month and Year 5
- tac_79
-
- Replies
- 5
- Views
- 2.2k
5
-
-
-
-
Can A Vlookup W/Search Function Work On A Substring of Text? 6
- MexicoGuy
-
- Replies
- 6
- Views
- 2.2k
6
-
-
-
-
VBA to insert IF formula to convert dates to DD/MM/YYYY 8
- Rovi
-
- Replies
- 8
- Views
- 2.2k
8
-
-
-
-
Petty Cash Template - Keep cell blank until data entered 3
- Chaffrin
-
- Replies
- 3
- Views
- 2.2k
3
-
-
-
-
YTD using dynamic spilled array 11
- MatthewHart
-
- Replies
- 11
- Views
- 2.1k
11
-
-
-
-
Archery scorecard for Top 4 Female scores then the Top 8 scores 6
- shinobi09
-
- Replies
- 6
- Views
- 2.1k
6
-
-
-
-
vlookup cell values only if date on adjacent column less than requested. INDEX/MATCH? 9
- Elusive
-
- Replies
- 9
- Views
- 2.1k
9
-
-
-
-
Trying to pull specific data from sheet1 to other sheets if it meets criteria 10
- blade671
-
- Replies
- 10
- Views
- 2.1k
10
-
-
-
-
select by data validation list to highlight the cells 15
- sathishsusa
-
- Replies
- 15
- Views
- 2.1k
15
-
-
-
-
Auto Add/Subtract 10
- JJeffery99
-
- Replies
- 10
- Views
- 2.1k
10
-
-
-
-
IFERROR VLOOKUP MAX value 8
- ItsSugarBunny
-
- Replies
- 8
- Views
- 2.1k
8
-
-
-
-
Positive Correlation but Negative correlation in Regression. 4
- Jontini
-
- Replies
- 4
- Views
- 2.1k
4
-
-
-
-
Sumif with Offset 2
- jvalente
-
- Replies
- 2
- Views
- 2.1k
2
-
-
-
-
Highlight largest value cell in range based on other columns 15
- paul789
-
- Replies
- 15
- Views
- 2.1k
15
-
-
-
-
Sumproduct with blank criteria 7
- DaneMark
-
- Replies
- 7
- Views
- 2.1k
7
-
-
-
-
Combine Large and Sumif - Array formula 4
- London.London
-
- Replies
- 4
- Views
- 2.1k
4
-
-
-
-
alert levels 12
- zohar
-
- Replies
- 12
- Views
- 2.1k
12
-
-
-
-
Replace a row number with a dynamic cell value 3
- acat
-
- Replies
- 3
- Views
- 2k
3
-