Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Match a value against a date and enter the matched value 41
- khanaran
March 21, 2021 at 6:59 AM
- khanaran
April 1, 2021 at 6:44 PM
-
- Replies
- 41
- Views
- 4.5k
41
-
-
-
-
Blank cells replace zeros 30
- CJamesUK
October 27, 2020 at 5:03 PM
- CJamesUK
November 10, 2020 at 11:53 AM
-
- Replies
- 30
- Views
- 4.1k
30
-
-
-
-
Multiple returns with 2 criteria from another workbook 29
- xsmurf
March 19, 2022 at 1:22 PM
- xsmurf
May 23, 2023 at 4:02 PM
-
- Replies
- 29
- Views
- 2.4k
29
-
-
-
-
Exact same formula different results. 28
- her.rockstar
May 9, 2017 at 7:31 PM
- her.rockstar
June 15, 2017 at 1:02 PM
-
- Replies
- 28
- Views
- 4.4k
28
-
-
-
-
PTO Accrual 27
- pianolady30
July 19, 2019 at 4:03 PM
- pianolady30
November 21, 2019 at 7:56 PM
-
- Replies
- 27
- Views
- 3.8k
27
-
-
-
-
Excel-Weighted Average using Words, NOT Numbers! 26
- mariadnj
December 28, 2017 at 10:17 PM
- mariadnj
January 3, 2018 at 4:01 PM
-
- Replies
- 26
- Views
- 2.2k
26
-
-
-
-
How to use indirect formula to show value AND formatting? 26
- carissa
July 4, 2017 at 5:22 AM
- carissa
July 4, 2017 at 10:49 AM
-
- Replies
- 26
- Views
- 5.3k
26
-
-
-
-
Counting unique rows 24
- schweggen
January 4, 2020 at 3:03 PM
- schweggen
March 26, 2020 at 12:46 PM
-
- Replies
- 24
- Views
- 3.4k
24
-
-
-
-
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
-
-
-
-
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
-
-
-
-
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.3k
23
-
-
-
-
I want Vlookup to return Formula and take cell reference from Target sheet. 22
- nilaymohit
January 8, 2020 at 11:14 AM
- nilaymohit
February 20, 2020 at 1:26 PM
-
- Replies
- 22
- Views
- 4.8k
22
-
-
-
-
sorting and presenting top values only once 22
- nircom
September 12, 2018 at 2:26 PM
- nircom
September 14, 2018 at 2:16 PM
-
- Replies
- 22
- Views
- 2.4k
22
-
-
-
-
Select Odd Rows from Named Range 21
- Cobstillaware
January 17, 2023 at 10:00 PM
- Cobstillaware
January 30, 2023 at 7:27 AM
-
- Replies
- 21
- Views
- 2.8k
21
-
-
-
-
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
-
-
-
-
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
-
-
-
-
sum cells in an excel column that fall between cells that fit a specific criteria? 20
- Laura Garnham
September 26, 2018 at 3:19 PM
- Laura Garnham
October 9, 2018 at 8:36 AM
-
- Replies
- 20
- Views
- 1.8k
20
-
-
-
-
COUNT two or more consecutive text values and check each if it's +/- than a value 20
- aspasovski86
August 20, 2018 at 11:24 PM
- aspasovski86
August 27, 2018 at 2:04 PM
-
- Replies
- 20
- Views
- 2.1k
20
-
-
-
-
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
-
-
-
-
Find Max number value from text-number cell? 20
- B.W.B.
September 8, 2016 at 1:50 PM
- B.W.B.
September 26, 2016 at 8:39 PM
-
- Replies
- 20
- Views
- 4.6k
20
-