Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
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
-
-
-
-
Vlookup and If formula 3
- DaveSharpe79
January 22, 2019 at 10:58 AM
- DaveSharpe79
January 24, 2019 at 10:15 PM
-
- Replies
- 3
- Views
- 637
3
-
-
-
-
Analysing Data between multiple ranges 1
- DaveSharpe79
June 29, 2018 at 3:51 PM
- DaveSharpe79
July 11, 2018 at 2:14 AM
-
- Replies
- 1
- Views
- 424
1
-
-
-
-
Excel - Sumifs/data collection date range query 4
- DaveSharpe79
July 25, 2017 at 4:16 PM
- DaveSharpe79
August 20, 2017 at 2:54 PM
-
- Replies
- 4
- Views
- 853
4
-
-
-
-
Removing Characters out of a long string of characters via formula 5
- DaveSharpe79
February 15, 2017 at 9:00 AM
- DaveSharpe79
February 16, 2017 at 8:07 AM
-
- Replies
- 5
- Views
- 915
5
-
-
-
-
Convert Time into Hours in Excel 1
- DaveSharpe79
February 14, 2017 at 6:16 PM
- DaveSharpe79
February 15, 2017 at 6:33 PM
-
- Replies
- 1
- Views
- 554
1
-
-
-
-
Using SUBTOTAL formula within an IF formula 2
- davec0864
June 8, 2022 at 5:36 PM
- davec0864
June 13, 2022 at 2:44 PM
-
- Replies
- 2
- Views
- 1.5k
2
-
-
-
-
Move data from cells in a vertical list to create a horizontal list 8
- Dave0608
August 30, 2019 at 11:46 AM
- Dave0608
September 2, 2019 at 8:05 AM
-
- Replies
- 8
- Views
- 1.2k
8
-
-
-
-
Generate cells with values from other cells 19
- DataWarrior
April 30, 2016 at 7:27 PM
- DataWarrior
May 16, 2016 at 6:10 AM
-
- Replies
- 19
- Views
- 3.7k
19
-
-
-
-
Check for non blank cells in a specified date range across 2 work sheets 4
- darth_chunk
November 16, 2017 at 5:36 PM
- darth_chunk
November 17, 2017 at 12:13 PM
-
- Replies
- 4
- Views
- 714
4
-
-
-
-
Conditional Formatting: based on whether 2 separate cells contain any value 7
- darth_chunk
November 8, 2017 at 2:58 PM
- darth_chunk
November 14, 2017 at 3:19 PM
-
- Replies
- 7
- Views
- 1.1k
7
-
-
-
-
Update Validation list from another cell 2
- Darryl256
December 4, 2017 at 5:39 AM
- Darryl256
December 5, 2017 at 3:36 AM
-
- Replies
- 2
- Views
- 290
2
-
-
-
-
Count overlapping time periods with condition
- Daphilo
June 21, 2022 at 4:44 PM
- Daphilo
June 21, 2022 at 4:44 PM
-
- Replies
- 0
- Views
- 561
-
-
-
-
The Excel links between 2 files are lost after sending them to a new PC. 4
- Dapante
May 14, 2020 at 10:34 AM
- Dapante
May 15, 2020 at 1:50 PM
-
- Replies
- 4
- Views
- 1.6k
4
-
-
-
-
Multi Criteria lookup with dates 4
- Danyam21
November 1, 2018 at 4:31 PM
- Danyam21
November 4, 2018 at 4:58 PM
-
- Replies
- 4
- Views
- 752
4
-
-
-
-
DELETE substring of text between text 11
- DannyGIS
April 2, 2019 at 10:05 PM
- DannyGIS
April 4, 2019 at 1:32 AM
-
- Replies
- 11
- Views
- 1.4k
11
-
-
-
-
Formula with cap 10
- DANGPS
February 8, 2023 at 10:21 AM
- DANGPS
February 23, 2023 at 10:04 AM
-
- Replies
- 10
- Views
- 654
10
-
-
-
-
Sumproduct with blank criteria 7
- DaneMark
August 10, 2016 at 9:27 PM
- DaneMark
August 23, 2016 at 7:20 AM
-
- Replies
- 7
- Views
- 2.4k
7
-
-
-
-
Cell Value Fill Based on Color 11
- dan_jordan84
February 10, 2021 at 2:00 PM
- dan_jordan84
February 10, 2021 at 5:19 PM
-
- Replies
- 11
- Views
- 1.6k
11
-
-
-
-
move cell values in Description from colums onto the same row based on a key 2
- Daidin
July 27, 2016 at 11:05 AM
- Daidin
July 28, 2016 at 12:09 PM
-
- Replies
- 2
- Views
- 969
2
-