Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Vlookup to subtract values across worksheets 9
- RobertJ
August 20, 2016 at 8:01 AM
- RobertJ
August 20, 2016 at 9:58 AM
-
- Replies
- 9
- Views
- 5.5k
9
-
-
-
-
Excel says: You've entered too many arguments for this function: 4
- Trish123
November 23, 2016 at 3:15 PM
- Trish123
December 12, 2016 at 7:02 PM
-
- Replies
- 4
- Views
- 5.5k
4
-
-
-
-
Convert pounds and ounces to decimal and other number questions 11
- noyb1982
August 3, 2018 at 11:13 PM
- noyb1982
August 4, 2018 at 9:37 PM
-
- Replies
- 11
- Views
- 5.4k
11
-
-
-
-
Find max value from vlookup against multiple sheets 12
- CompleXcel
April 26, 2018 at 7:59 AM
- CompleXcel
August 14, 2018 at 4:50 AM
-
- Replies
- 12
- Views
- 5.3k
12
-
-
-
-
Index Small function to skip blank rows 8
- dloc_26
March 28, 2017 at 3:13 PM
- dloc_26
April 9, 2017 at 10:16 AM
-
- Replies
- 8
- Views
- 5.3k
8
-
-
-
-
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
-
-
-
-
Xlookup with duplicate values in return array 3
- Aksaunder
March 21, 2021 at 12:48 PM
- Aksaunder
March 21, 2021 at 1:54 PM
-
- Replies
- 3
- Views
- 5.2k
3
-
-
-
-
Format Cell Color if Adjacent cell is blank 4
- scubastu01
August 17, 2017 at 6:11 PM
- scubastu01
August 17, 2017 at 7:18 PM
-
- Replies
- 4
- Views
- 5.1k
4
-
-
-
-
Converting Quarterly Data to Monthly Data 1
- Rafaelbrians
September 27, 2018 at 5:32 AM
- Rafaelbrians
September 27, 2018 at 8:17 AM
-
- Replies
- 1
- Views
- 5.1k
1
-
-
-
-
Excel formula to show text only IF another cell is greater than 0 5
- Aikosassie2
April 14, 2020 at 1:55 PM
- Aikosassie2
April 16, 2020 at 6:40 PM
-
- Replies
- 5
- Views
- 4.8k
5
-
-
-
-
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
-
-
-
-
If cell is not empty, copy row... 9
- micvoo
December 5, 2020 at 11:55 AM
- micvoo
December 15, 2020 at 1:46 PM
-
- Replies
- 9
- Views
- 4.6k
9
-
-
-
-
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.5k
20
-
-
-
-
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
-
-
-
-
calculate the number of years and months as of today and round to the nearest year 2
- milgrl3
July 10, 2017 at 4:00 PM
- milgrl3
July 10, 2017 at 4:15 PM
-
- Replies
- 2
- Views
- 4.4k
2
-
-
-
-
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
-
-
-
-
VLookup Formula that can change Negative number to Positive and leave Positive 1
- Washerz
September 25, 2018 at 4:30 PM
- Washerz
September 25, 2018 at 5:32 PM
-
- Replies
- 1
- Views
- 4.3k
1
-
-
-
-
Highlight if Cell contains asterisk(*) 8
- Anna Mary
July 15, 2021 at 1:32 PM
- Anna Mary
July 22, 2021 at 8:52 PM
-
- Replies
- 8
- Views
- 4.3k
8
-
-
-
-
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
-
-
-
-
Need help in COUNTIF formula 11
- elsuji
May 28, 2021 at 6:16 PM
- elsuji
July 30, 2021 at 7:44 AM
-
- Replies
- 11
- Views
- 4k
11
-