Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Parse cell for 1 of 3 values, return corresponding string value 5
- Dougmeister
April 19, 2017 at 2:33 PM
- Dougmeister
April 19, 2017 at 4:49 PM
-
- Replies
- 5
- Views
- 849
5
-
-
-
-
WEEKDAYNAME function not working... error #NAME? (Excel 2013) 1
- Dougmeister
March 23, 2017 at 1:22 PM
- Dougmeister
March 23, 2017 at 1:46 PM
-
- Replies
- 1
- Views
- 1.1k
1
-
-
-
-
Replace "Sum of..." in GETPIVOTDATA with a relative reference 2
- DoubleJay
April 6, 2020 at 1:34 AM
- DoubleJay
April 7, 2020 at 12:32 AM
-
- Replies
- 2
- Views
- 1.5k
2
-
-
-
-
Formula (Possibly and Array) 2
- Dorkus
July 18, 2019 at 3:52 PM
- Dorkus
July 19, 2019 at 9:26 AM
-
- Replies
- 2
- Views
- 512
2
-
-
-
-
Calculating the "initial Investment Value" with CAGR formula and average value 11
- dmzeigler
November 20, 2018 at 3:58 PM
- dmzeigler
November 21, 2018 at 6:51 PM
-
- Replies
- 11
- Views
- 1k
11
-
-
-
-
Change color of cell based on time since cell was filled 1
- dmcafee
August 23, 2023 at 8:17 PM
- dmcafee
August 24, 2023 at 12:34 PM
-
- Replies
- 1
- Views
- 248
1
-
-
-
-
COUNTIFS on Table and Between Dates 3
- dloc_26
May 6, 2020 at 2:45 PM
- dloc_26
May 6, 2020 at 6:07 PM
-
- Replies
- 3
- Views
- 972
3
-
-
-
-
Lookup between a starting word and finishing word 4
- dloc_26
August 22, 2019 at 8:50 PM
- dloc_26
August 23, 2019 at 4:53 PM
-
- Replies
- 4
- Views
- 888
4
-
-
-
-
Optimizing without Macros 2
- dloc_26
December 4, 2018 at 5:47 PM
- dloc_26
December 10, 2018 at 8:26 PM
-
- Replies
- 2
- Views
- 523
2
-
-
-
-
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
-
-
-
-
excel formula to find quarter 3
- dkool
April 11, 2022 at 8:42 AM
- dkool
April 11, 2022 at 11:21 AM
-
- Replies
- 3
- Views
- 507
3
-
-
-
-
Excel formula or VBA code for extracting external file links 1
- dkool
October 6, 2021 at 5:35 AM
- dkool
October 6, 2021 at 6:08 AM
-
- Replies
- 1
- Views
- 380
1
-
-
-
-
excel formula to lookup year and sum 3
- dkool
March 4, 2021 at 5:01 PM
- dkool
March 4, 2021 at 6:47 PM
-
- Replies
- 3
- Views
- 676
3
-
-
-
-
need VBA code to find unique values, create sheets and pste data 3
- dkool
March 5, 2020 at 12:56 PM
- dkool
March 5, 2020 at 2:20 PM
-
- Replies
- 3
- Views
- 777
3
-
-
-
-
excel formula to lookup number and give ext 2
- dkool
May 5, 2019 at 10:38 AM
- dkool
May 6, 2019 at 7:17 AM
-
- Replies
- 2
- Views
- 577
2
-
-
-
-
excel formula needed to lookup values 3
- dkool
January 2, 2019 at 1:06 PM
- dkool
January 2, 2019 at 4:29 PM
-
- Replies
- 3
- Views
- 809
3
-
-
-
-
excel formula needed for date 3
- dkool
August 14, 2018 at 3:04 PM
- dkool
August 16, 2018 at 10:02 AM
-
- Replies
- 3
- Views
- 757
3
-
-
-
-
excel formulae to find grade by certain conditions 1
- dkool
April 24, 2018 at 12:08 PM
- dkool
April 24, 2018 at 3:10 PM
-
- Replies
- 1
- Views
- 343
1
-
-
-
-
HELP with DAX Formulae 2
- djmoly
March 16, 2019 at 12:25 AM
- djmoly
March 18, 2019 at 6:37 PM
-
- Replies
- 2
- Views
- 696
2
-
-
-
-
Average working days based on 2 criteria 9
- Djack92
November 23, 2021 at 10:34 AM
- Djack92
November 24, 2021 at 8:50 AM
-
- Replies
- 9
- Views
- 1.3k
9
-