Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
"tilde" in vlookup formula 13
- Anri
March 22, 2017 at 5:42 AM
- Anri
March 22, 2017 at 2:04 PM
-
- Replies
- 13
- Views
- 4k
13
-
-
-
-
AverageIf #DIV/0! error 10
- Murph0625
February 16, 2017 at 8:43 PM
- Murph0625
February 17, 2017 at 6:21 PM
-
- Replies
- 10
- Views
- 4k
10
-
-
-
-
concatenateif formula not working ? 5
- jacjas
July 21, 2017 at 3:34 PM
- jacjas
July 24, 2017 at 9:18 AM
-
- Replies
- 5
- Views
- 3.8k
5
-
-
-
-
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
-
-
-
-
Drag down formula and change column names in order 11
- onexc
December 19, 2017 at 7:45 PM
- onexc
December 20, 2017 at 8:09 PM
-
- Replies
- 11
- Views
- 3.7k
11
-
-
-
-
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
-
-
-
-
Formula: Test for overlapping number ranges 3
- jdawson422
April 11, 2016 at 7:08 PM
- jdawson422
June 28, 2017 at 5:04 PM
-
- Replies
- 3
- Views
- 3.5k
3
-
-
-
-
Determine if "Active" if hire and term date are within cells range 2
- Delta729
March 26, 2016 at 6:08 PM
- Delta729
April 1, 2016 at 6:00 AM
-
- Replies
- 2
- Views
- 3.5k
2
-
-
-
-
Finding the Median for certain dates from a list of data 12
- moyad612013
May 11, 2020 at 8:37 PM
- moyad612013
May 15, 2020 at 1:11 PM
-
- Replies
- 12
- Views
- 3.5k
12
-
-
-
-
Combine Large and Sumif - Array formula 4
- London.London
June 18, 2018 at 4:25 PM
- London.London
June 20, 2018 at 1:50 PM
-
- Replies
- 4
- Views
- 3.5k
4
-
-
-
-
compile error expected variable or procedure not module 2
- abdiwahab
May 27, 2016 at 6:18 AM
- abdiwahab
May 27, 2016 at 6:55 AM
-
- Replies
- 2
- Views
- 3.5k
2
-
-
-
-
Hide duplicate running total values. 11
- Skylane60
May 12, 2017 at 11:16 PM
- Skylane60
May 13, 2017 at 10:00 PM
-
- Replies
- 11
- Views
- 3.5k
11
-
-
-
-
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
-
-
-
-
COUNTIFS with dynamic named ranges 14
- Baber62
July 12, 2017 at 2:42 PM
- Baber62
July 26, 2017 at 8:46 AM
-
- Replies
- 14
- Views
- 3.4k
14
-
-
-
-
How to create an excel formula that will average the 2 highest values that are separated by a 3 week difference in testing date 19
- healthguy
February 24, 2020 at 6:20 PM
- healthguy
March 2, 2020 at 9:49 PM
-
- Replies
- 19
- Views
- 3.4k
19
-
-
-
-
Extract data fields from wrapped text cell 7
- hugletank
May 4, 2020 at 6:52 PM
- hugletank
May 6, 2020 at 5:06 PM
-
- Replies
- 7
- Views
- 3.3k
7
-
-
-
-
countifs with specific name between two dates 18
- hahsj
November 29, 2019 at 10:51 PM
- hahsj
February 20, 2020 at 1:42 PM
-
- Replies
- 18
- Views
- 3.3k
18
-
-
-
-
Custom searchable drop down list..... 8
- nmkhan3010
March 13, 2020 at 11:59 AM
- nmkhan3010
March 17, 2020 at 11:51 PM
-
- Replies
- 8
- Views
- 3.3k
8
-
-
-
-
Searchable Dropdown List is working as a normal dropdown list in protected worksheet 8
- MudasGrid
July 30, 2021 at 5:23 PM
- MudasGrid
January 24, 2022 at 12:46 AM
-
- Replies
- 8
- Views
- 3.3k
8
-
-
-
-
Revised vba to fill blanks in a range 19
- kumarsatish
October 5, 2019 at 4:04 AM
- kumarsatish
October 11, 2019 at 6:32 PM
-
- Replies
- 19
- Views
- 3.2k
19
-