Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Every nth cell into multiple cells 1
- FINgers
June 7, 2021 at 12:18 AM
- FINgers
June 7, 2021 at 12:30 AM
-
- Replies
- 1
- Views
- 325
1
-
-
-
-
index match using multiple spreadsheets return text YES OR NO 1
- emthaolinh
May 16, 2021 at 3:06 PM
- emthaolinh
May 17, 2021 at 1:01 PM
-
- Replies
- 1
- Views
- 743
1
-
-
-
-
Calculating a numeric score from a qualitative score 1
- la_coyote
May 13, 2021 at 2:46 PM
- la_coyote
May 13, 2021 at 5:31 PM
-
- Replies
- 1
- Views
- 431
1
-
-
-
-
Problem using Index/Match - how to handle duplicate amounts and dates 1
- Jaffey
April 25, 2021 at 9:53 PM
- Jaffey
April 26, 2021 at 6:09 AM
-
- Replies
- 1
- Views
- 419
1
-
-
-
-
Erroneous #NAME? error that goes away when I drag the formula back over the cells showing the error 1
- browncoat
April 20, 2021 at 5:17 AM
- browncoat
April 20, 2021 at 6:34 AM
-
- Replies
- 1
- Views
- 354
1
-
-
-
-
Find common part number amongst various suppiers 1
- mljohn
March 24, 2021 at 10:16 PM
- mljohn
March 24, 2021 at 11:47 PM
-
- Replies
- 1
- Views
- 417
1
-
-
-
-
How to calculate variance and ratio total open and closed tickets? 1
- Xani
March 20, 2021 at 8:25 AM
- Xani
March 20, 2021 at 9:20 AM
-
- Replies
- 1
- Views
- 554
1
-
-
-
-
Drop down boxes and Pivot Tables 1
- kramer100
February 18, 2021 at 9:38 PM
- kramer100
February 19, 2021 at 7:55 AM
-
- Replies
- 1
- Views
- 423
1
-
-
-
-
find a match using vlookup (but not just first entry) 1
- POQUACK
January 21, 2021 at 3:51 PM
- POQUACK
January 21, 2021 at 4:17 PM
-
- Replies
- 1
- Views
- 401
1
-
-
-
-
INDEX MATCH of Two Lookup_Array 1
- IEXCELMYWORK
January 17, 2021 at 9:35 AM
- IEXCELMYWORK
January 17, 2021 at 11:13 AM
-
- Replies
- 1
- Views
- 499
1
-
-
-
-
Conditional formatting formula to highlight alternate groupings of duplicate dates 1
- abaker77
November 26, 2020 at 6:28 PM
- abaker77
January 29, 2021 at 5:13 PM
-
- Replies
- 1
- Views
- 876
1
-
-
-
-
Find a row with the oldest date 1
- GradB
November 26, 2020 at 6:35 AM
- GradB
November 26, 2020 at 10:31 AM
-
- Replies
- 1
- Views
- 648
1
-
-
-
-
Providing Notification of When a Task is Due Based on Dates 1
- VWRSue
October 15, 2020 at 7:56 PM
- VWRSue
October 16, 2020 at 3:37 AM
-
- Replies
- 1
- Views
- 768
1
-
-
-
-
Formula for Conditional Formatting in Tables 1
- Crazy Brit
September 28, 2020 at 7:54 PM
- Crazy Brit
September 29, 2020 at 6:20 AM
-
- Replies
- 1
- Views
- 1.1k
1
-
-
-
-
Search bar using FILTER formula 1
- chester1993
September 21, 2020 at 10:45 AM
- chester1993
September 21, 2020 at 12:58 PM
-
- Replies
- 1
- Views
- 647
1
-
-
-
-
Excel SUMIFS Formula dashboard 1
- Amyhosh11
September 13, 2020 at 12:16 PM
- Amyhosh11
September 13, 2020 at 2:18 PM
-
- Replies
- 1
- Views
- 439
1
-
-
-
-
COUNTA, SUMIF and Concatenate 1
- El Gallo
September 12, 2020 at 8:27 AM
- El Gallo
September 12, 2020 at 9:36 PM
-
- Replies
- 1
- Views
- 870
1
-
-
-
-
Add a calculated field to a pivot table 1
- cobber1418
August 31, 2020 at 10:22 PM
- cobber1418
August 31, 2020 at 11:59 PM
-
- Replies
- 1
- Views
- 581
1
-
-
-
-
Apostrophe Issue with Character Count 1
- RSquirrel
August 8, 2020 at 6:22 PM
- RSquirrel
August 8, 2020 at 8:16 PM
-
- Replies
- 1
- Views
- 583
1
-
-
-
-
Count number of consecutive values after 3rd occurrence 1
- MegOzam
August 7, 2020 at 8:33 AM
- MegOzam
August 7, 2020 at 11:09 AM
-
- Replies
- 1
- Views
- 498
1
-