Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Count number of consecutive values based on criteria 20
- Nathan_E
September 22, 2017 at 4:08 PM
- Nathan_E
October 18, 2017 at 9:01 PM
-
- Replies
- 20
- Views
- 17k
20
-
-
-
-
OFFSET formula to ignore cell with a blank formula 6
- Nagin
July 19, 2017 at 10:05 AM
- Nagin
July 19, 2017 at 7:09 PM
-
- Replies
- 6
- Views
- 13k
6
-
-
-
-
Using of VLOOKUP and ISNUMBER 8
- onexc
June 24, 2017 at 11:14 PM
- onexc
June 25, 2017 at 10:34 PM
-
- Replies
- 8
- Views
- 12k
8
-
-
-
-
Formula to convert a gregorian date to a chinese date 21
- khanaran
April 22, 2021 at 9:31 AM
- khanaran
May 8, 2021 at 3:47 PM
-
- Replies
- 21
- Views
- 10k
21
-
-
-
-
How to get rid of 1/0/1900 in IF formula? 3
- FaKest
April 23, 2020 at 8:14 PM
- FaKest
April 24, 2020 at 12:05 PM
-
- Replies
- 3
- Views
- 10k
3
-
-
-
-
vlookup #n/a error when values exist 5
- ANku86
December 13, 2016 at 7:10 PM
- ANku86
December 13, 2016 at 10:12 PM
-
- Replies
- 5
- Views
- 9.4k
5
-
-
-
-
Formula to return which quartile a given number falls in 3
- CCA BSM
February 6, 2017 at 4:54 PM
- CCA BSM
February 6, 2017 at 11:10 PM
-
- Replies
- 3
- Views
- 8k
3
-
-
-
-
How to use datepicker with custom format 1
- eranp03
June 22, 2019 at 2:53 PM
- eranp03
July 8, 2019 at 6:21 AM
-
- Replies
- 1
- Views
- 7.9k
1
-
-
-
-
Using INDIRECT in the Formula That Defines a Graph's Data Range 10
- OldFella
June 20, 2017 at 1:38 PM
- OldFella
June 20, 2017 at 4:11 PM
-
- Replies
- 10
- Views
- 7.9k
10
-
-
-
-
Index / Match + Sort / Filter Issue 9
- swillisam
October 25, 2016 at 10:59 AM
- swillisam
October 25, 2016 at 4:35 PM
-
- Replies
- 9
- Views
- 7.3k
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
-
-
-
-
Flag if data is in top 80% of range 8
- goin4boge
October 24, 2016 at 8:36 PM
- goin4boge
October 25, 2016 at 7:50 PM
-
- Replies
- 8
- Views
- 6.7k
8
-
-
-
-
Print to PDF with Filename and Date / Time stamp 3
- jl2509
November 25, 2017 at 8:53 AM
- jl2509
November 25, 2017 at 11:36 AM
-
- Replies
- 3
- Views
- 6.6k
3
-
-
-
-
double click macro for table 10
- nitroxhaha
January 21, 2020 at 11:36 PM
- nitroxhaha
February 20, 2020 at 1:43 PM
-
- Replies
- 10
- Views
- 6.5k
10
-
-
-
-
Custom Week Number - Last Saturday in December is Week 1 23
- m4Owen
November 27, 2019 at 2:12 PM
- m4Owen
February 23, 2020 at 7:32 AM
-
- Replies
- 23
- Views
- 6.2k
23
-
-
-
-
Find underline and bold text with cells. 14
- cya
March 20, 2019 at 10:32 PM
- cya
March 22, 2019 at 3:56 PM
-
- Replies
- 14
- Views
- 6.1k
14
-
-
-
-
Remove slashes from date 2
- jlsprink
January 30, 2018 at 10:24 PM
- jlsprink
January 31, 2018 at 9:54 AM
-
- Replies
- 2
- Views
- 6k
2
-
-
-
-
Calculate overtime based on 8 hour day / 44 hour week 10
- Excel Noob
December 15, 2016 at 10:02 PM
- Excel Noob
December 22, 2016 at 1:50 PM
-
- Replies
- 10
- Views
- 5.9k
10
-
-
-
-
Indirect/substitute formula help 13
- freddie0
April 3, 2020 at 7:07 PM
- freddie0
April 22, 2020 at 1:53 PM
-
- Replies
- 13
- Views
- 5.6k
13
-
-
-
-
Index Match with multiple criteria and partial match 2
- Desauv
June 11, 2019 at 1:23 PM
- Desauv
June 11, 2019 at 2:07 PM
-
- Replies
- 2
- Views
- 5.6k
2
-