Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Index Match where ranges are given in cell value 2
- luzmen
November 2, 2017 at 5:54 AM
- luzmen
November 2, 2017 at 8:16 AM
-
- Replies
- 2
- Views
- 551
2
-
-
-
-
Converting a fraction ... 2
- Mark Likos
June 6, 2018 at 3:18 PM
- Mark Likos
June 6, 2018 at 5:19 PM
-
- Replies
- 2
- Views
- 550
2
-
-
-
-
Autofill Dates between 2 static dates 2
- jl2509
October 3, 2018 at 1:25 PM
- jl2509
November 11, 2018 at 7:53 AM
-
- Replies
- 2
- Views
- 549
2
-
-
-
-
Linking entered dates to column location 1
- JamesK1993
April 18, 2017 at 10:50 AM
- JamesK1993
April 18, 2017 at 10:52 AM
-
- Replies
- 1
- Views
- 548
1
-
-
-
-
Complex COUNTIFS? 2
- rinconpaul
February 1, 2018 at 9:21 AM
- rinconpaul
February 1, 2018 at 3:52 PM
-
- Replies
- 2
- Views
- 547
2
-
-
-
-
Concatenate in 4 digit 1
- zoullat
September 9, 2017 at 5:22 PM
- zoullat
September 9, 2017 at 9:33 PM
-
- Replies
- 1
- Views
- 547
1
-
-
-
-
using INDIRECT to set structured table reference in formula and return COUNTIF result based on another column value 2
- alz1
September 24, 2020 at 12:17 AM
- alz1
September 24, 2020 at 1:10 PM
-
- Replies
- 2
- Views
- 546
2
-
-
-
-
Finding Working Day from the Calendar Date using a formula 1
- kumuda2505
February 20, 2017 at 2:02 AM
- kumuda2505
February 20, 2017 at 9:05 AM
-
- Replies
- 1
- Views
- 546
1
-
-
-
-
SUMPRODUCT One of the best formulas in Excel 1
- gregh
May 14, 2018 at 1:54 AM
- gregh
May 14, 2018 at 4:45 AM
-
- Replies
- 1
- Views
- 545
1
-
-
-
-
Formula/VLOOKUP for multiple 'greater than' criteria to return multiple results 2
- cm882653
March 23, 2017 at 9:35 AM
- cm882653
March 24, 2017 at 2:19 AM
-
- Replies
- 2
- Views
- 545
2
-
-
-
-
Formula to count times a specific number will divide into another + rounding rules 1
- j6bennett1
February 10, 2017 at 8:29 PM
- j6bennett1
February 11, 2017 at 2:02 AM
-
- Replies
- 1
- Views
- 545
1
-
-
-
-
automatic static date 1
- Pedro003
May 10, 2022 at 4:12 PM
- Pedro003
June 13, 2022 at 7:18 PM
-
- Replies
- 1
- Views
- 544
1
-
-
-
-
Formula to look at dates and bring back value 1
- excellquestion
February 1, 2017 at 10:15 PM
- excellquestion
February 2, 2017 at 1:08 PM
-
- Replies
- 1
- Views
- 544
1
-
-
-
-
Validation List using a Table 3
- mar050703
November 11, 2017 at 2:00 PM
- mar050703
November 12, 2017 at 3:53 PM
-
- Replies
- 3
- Views
- 543
3
-
-
-
-
Average data when cells contain text and data 3
- seyah
March 7, 2019 at 12:23 AM
- seyah
March 7, 2019 at 9:32 PM
-
- Replies
- 3
- Views
- 541
3
-
-
-
-
Instead of Indirect 1
- steveda
December 24, 2018 at 4:55 PM
- steveda
January 3, 2019 at 10:42 AM
-
- Replies
- 1
- Views
- 541
1
-
-
-
-
Sla Hours Between Two Dates
- tr1face
October 15, 2021 at 6:48 PM
- tr1face
October 15, 2021 at 6:48 PM
-
- Replies
- 0
- Views
- 540
-
-
-
-
Formula for adding previous sheets 2
- jberena
March 18, 2017 at 11:01 PM
- jberena
March 19, 2017 at 8:01 AM
-
- Replies
- 2
- Views
- 540
2
-
-
-
-
sum cells only if adjacent cell has value 1
- Fleur
July 27, 2017 at 1:18 PM
- Fleur
August 13, 2017 at 9:05 AM
-
- Replies
- 1
- Views
- 539
1
-
-
-
-
Roundup and IF Formula 1
- jacjas
March 28, 2017 at 12:50 PM
- jacjas
March 28, 2017 at 1:11 PM
-
- Replies
- 1
- Views
- 539
1
-