Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
SUMIFS or SUMPRODUCT both returning #VALUE error 2
- DezB
March 16, 2023 at 8:23 AM
- DezB
March 16, 2023 at 8:42 AM
-
- Replies
- 2
- Views
- 335
2
-
-
-
-
Conditional Formatting to highlight column based on date in row 5
- DezB
March 14, 2023 at 8:51 AM
- DezB
March 14, 2023 at 10:27 AM
-
- Replies
- 5
- Views
- 524
5
-
-
-
-
INDEX/MATCH Formula - beyond me 11
- DezB
February 24, 2023 at 9:56 AM
- DezB
February 24, 2023 at 12:12 PM
-
- Replies
- 11
- Views
- 575
11
-
-
-
-
Adding contents of cells based on month and location 9
- DezB
August 22, 2022 at 2:46 PM
- DezB
August 26, 2022 at 7:41 PM
-
- Replies
- 9
- Views
- 716
9
-
-
-
-
starting a formula from the next cell on from the previous formula 1
- DezB
August 10, 2022 at 11:56 AM
- DezB
October 12, 2022 at 5:31 PM
-
- Replies
- 1
- Views
- 482
1
-
-
-
-
Collate data from last x days based on todays date 7
- DezB
August 4, 2022 at 1:55 PM
- DezB
August 8, 2022 at 1:18 PM
-
- Replies
- 7
- Views
- 726
7
-
-
-
-
Match date in cell to the same date in a range and return value from cell below 2
- DezB
November 10, 2021 at 4:22 PM
- DezB
November 11, 2021 at 8:14 AM
-
- Replies
- 2
- Views
- 474
2
-
-
-
-
Count number of dates by month 4
- DezB
July 28, 2021 at 4:03 PM
- DezB
July 29, 2021 at 5:01 PM
-
- Replies
- 4
- Views
- 2.3k
4
-
-
-
-
Multiple vlookup 2
- DezB
June 21, 2021 at 4:55 PM
- DezB
July 28, 2021 at 4:06 PM
-
- Replies
- 2
- Views
- 660
2
-
-
-
-
Pop up chart 5
- DezB
May 18, 2021 at 12:28 PM
- DezB
May 18, 2021 at 2:58 PM
-
- Replies
- 5
- Views
- 1.1k
5
-
-
-
-
Lengthy SumIFS formulae 3
- DezB
March 9, 2020 at 2:49 PM
- DezB
March 10, 2020 at 4:28 PM
-
- Replies
- 3
- Views
- 705
3
-
-
-
-
Look for No or NO in a string and count 7
- DezB
January 9, 2020 at 10:46 AM
- DezB
February 20, 2020 at 1:48 PM
-
- Replies
- 7
- Views
- 1.9k
7
-
-
-
-
Dropdown selection based on previous dropdown selection 13
- DezB
April 3, 2019 at 11:53 AM
- DezB
April 10, 2019 at 9:39 AM
-
- Replies
- 13
- Views
- 1.7k
13
-
-
-
-
VLOOKUP Error 2
- DezB
February 5, 2018 at 11:03 AM
- DezB
February 5, 2018 at 11:45 AM
-
- Replies
- 2
- Views
- 423
2
-
-
-
-
Attendance Analysis 3
- DezB
February 2, 2018 at 12:16 PM
- DezB
February 2, 2018 at 2:39 PM
-
- Replies
- 3
- Views
- 613
3
-
-
-
-
Turn Surname and Firstname around 5
- DezB
January 31, 2018 at 3:26 PM
- DezB
February 1, 2018 at 8:13 AM
-
- Replies
- 5
- Views
- 733
5
-
-
-
-
IFERROR error 7
- DezB
January 9, 2018 at 8:38 PM
- DezB
January 9, 2018 at 9:56 PM
-
- Replies
- 7
- Views
- 918
7
-
-
-
-
networkdays.intl returns 1 if no dates entered 2
- DezB
November 28, 2017 at 11:04 AM
- DezB
December 4, 2017 at 9:58 AM
-
- Replies
- 2
- Views
- 835
2
-
-
-
-
Look for name in string and return data to another sheet 9
- DezB
October 30, 2017 at 3:21 PM
- DezB
November 2, 2017 at 8:43 AM
-
- Replies
- 9
- Views
- 999
9
-
-
-
-
IFERROR, ROUND and SUM together 2
- DezB
September 11, 2017 at 11:49 AM
- DezB
September 11, 2017 at 12:52 PM
-
- Replies
- 2
- Views
- 6.9k
2
-