Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Need help with VLOOKUP by WEEKNUM 11
- chobart46
October 19, 2019 at 2:33 PM
- chobart46
October 21, 2019 at 6:14 PM
-
- Replies
- 11
- Views
- 3.2k
11
-
-
-
-
INCREMENT NUMERICAL STRING BY 1 17
- Garth Lean
January 25, 2020 at 12:07 PM
- Garth Lean
February 20, 2020 at 1:31 PM
-
- Replies
- 17
- Views
- 3.2k
17
-
-
-
-
Expand multilevel information 19
- lsb2000
November 13, 2019 at 4:14 PM
- lsb2000
February 20, 2020 at 1:36 PM
-
- Replies
- 19
- Views
- 3.2k
19
-
-
-
-
Dynamic way to calculate the last 6 months average. 2
- FaKest
April 22, 2020 at 12:39 PM
- FaKest
April 23, 2020 at 12:51 PM
-
- Replies
- 2
- Views
- 3.1k
2
-
-
-
-
Last non-empty cell in the column based on three header rows that are criteria 16
- rehan kazi
June 6, 2021 at 6:42 AM
- rehan kazi
August 1, 2021 at 2:25 AM
-
- Replies
- 16
- Views
- 3.1k
16
-
-
-
-
Worsheet_change Multiple uses same sheet 21
- LearningXL
May 22, 2020 at 11:15 AM
- LearningXL
May 24, 2020 at 9:01 AM
-
- Replies
- 21
- Views
- 3.1k
21
-
-
-
-
Auto populating drop down lists/cells based on conditions 24
- Boycie92
July 25, 2017 at 12:47 PM
- Boycie92
July 26, 2017 at 2:16 PM
-
- Replies
- 24
- Views
- 3.1k
24
-
-
-
-
TREND Function to Ignore Zeros 7
- msquared99
April 19, 2019 at 1:54 PM
- msquared99
April 20, 2019 at 9:52 AM
-
- Replies
- 7
- Views
- 3k
7
-
-
-
-
Running count of occurrence in list using array formula with spill range 4
- Range Rover
August 17, 2020 at 10:38 AM
- Range Rover
August 21, 2020 at 1:46 PM
-
- Replies
- 4
- Views
- 3k
4
-
-
-
-
YTD calculations with multiple criteria 7
- EExcelHelp
February 5, 2020 at 4:03 PM
- EExcelHelp
February 6, 2020 at 8:28 AM
-
- Replies
- 7
- Views
- 3k
7
-
-
-
-
Copy data down and across range 24
- jl2509
November 22, 2018 at 9:57 PM
- jl2509
November 24, 2018 at 10:38 AM
-
- Replies
- 24
- Views
- 3k
24
-
-
-
-
Ignore blank cells in array formula 2
- artsjeroen
March 10, 2016 at 2:51 PM
- artsjeroen
March 10, 2016 at 3:38 PM
-
- Replies
- 2
- Views
- 3k
2
-
-
-
-
Index/Match Formula Disappears after Ctrl-Shift-Enter 10
- OldFella
June 17, 2017 at 8:03 AM
- OldFella
June 18, 2017 at 9:21 AM
-
- Replies
- 10
- Views
- 3k
10
-
-
-
-
Auto Add/Subtract 10
- JJeffery99
June 12, 2020 at 9:37 AM
- JJeffery99
June 12, 2020 at 8:28 PM
-
- Replies
- 10
- Views
- 3k
10
-
-
-
-
Calculate days between 2 dates 3
- angelic1
October 14, 2016 at 8:00 AM
- angelic1
October 19, 2016 at 8:50 AM
-
- Replies
- 3
- Views
- 2.9k
3
-
-
-
-
growing range 7
- Eusebious
August 5, 2021 at 6:10 PM
- Eusebious
August 6, 2021 at 6:42 PM
-
- Replies
- 7
- Views
- 2.9k
7
-
-
-
-
INDEX MATCH with multiple lookup_arrays/references 12
- B.W.B.
June 17, 2016 at 3:26 PM
- B.W.B.
September 3, 2016 at 8:30 AM
-
- Replies
- 12
- Views
- 2.8k
12
-
-
-
-
Identify Row Number on Different Sheet to complete COUNTIF on (in single formula) 6
- ruppk825
May 17, 2022 at 5:42 PM
- ruppk825
May 19, 2022 at 11:54 PM
-
- Replies
- 6
- Views
- 2.8k
6
-
-
-
-
lognormal graph 1
- aeonstorm
February 12, 2019 at 5:39 AM
- aeonstorm
February 16, 2019 at 8:26 AM
-
- Replies
- 1
- Views
- 2.8k
1
-
-
-
-
Return Specific Value from adjacent cell if values match 5
- JadeRae
May 11, 2016 at 8:53 PM
- JadeRae
May 11, 2016 at 10:54 PM
-
- Replies
- 5
- Views
- 2.8k
5
-