Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Formula for Next Available Number 2
- RedWings2020
July 6, 2023 at 7:32 PM
- RedWings2020
August 6, 2023 at 3:02 AM
-
- Replies
- 2
- Views
- 370
2
-
-
-
-
sum based on 2 row criteria values.
- reggieneo
January 20, 2018 at 8:23 AM
- reggieneo
January 20, 2018 at 8:23 AM
-
- Replies
- 0
- Views
- 257
-
-
-
-
Sumifs always returns ) 1
- reggieneo
June 23, 2018 at 4:34 PM
- reggieneo
June 23, 2018 at 6:27 PM
-
- Replies
- 1
- Views
- 340
1
-
-
-
-
find the closest match in one cell string to range of cells string (column) 1
- reggieneo
February 17, 2019 at 1:38 PM
- reggieneo
February 22, 2019 at 8:55 AM
-
- Replies
- 1
- Views
- 403
1
-
-
-
-
Last non-empty cell in the column based on three header rows that are criteria 16
- rehan kazi
June 6, 2021 at 6:42 AM
- rehan kazi
August 1, 2021 at 2:25 AM
-
- Replies
- 16
- Views
- 3.1k
16
-
-
-
-
Count time selected by year of date 2
- remco77a
March 5, 2020 at 2:06 PM
- remco77a
March 6, 2020 at 6:37 AM
-
- Replies
- 2
- Views
- 908
2
-
-
-
-
Combining Monthly Fee Totals by month, year, and location with Annual Fee Increases 14
- Retailmessiah
January 27, 2021 at 10:56 PM
- Retailmessiah
February 1, 2021 at 5:50 AM
-
- Replies
- 14
- Views
- 1.7k
14
-
-
-
-
Excel COUNTIF Not Working
- RhiJMcGuire
October 9, 2017 at 2:17 AM
- RhiJMcGuire
October 9, 2017 at 2:17 AM
-
- Replies
- 0
- Views
- 252
-
-
-
-
Formula Help 7
- RhiRhi1
April 26, 2018 at 8:17 PM
- RhiRhi1
April 27, 2018 at 12:45 PM
-
- Replies
- 7
- Views
- 738
7
-
-
-
-
Lookup rows and return STDEV.S of cells matching criteria in column headings 2
- RHUL
July 19, 2017 at 8:18 PM
- RHUL
July 20, 2017 at 1:36 PM
-
- Replies
- 2
- Views
- 588
2
-
-
-
-
Copy formulas with pattern 2
- ricardo9
July 16, 2017 at 12:31 AM
- ricardo9
July 16, 2017 at 4:59 PM
-
- Replies
- 2
- Views
- 584
2
-
-
-
-
Unique reference based on multiple columns 6
- Richard_C
January 22, 2019 at 3:30 PM
- Richard_C
January 23, 2019 at 2:36 PM
-
- Replies
- 6
- Views
- 950
6
-
-
-
-
SUMPRODUCT on 1 column and criteria on another columns
- richardd8x
December 3, 2018 at 11:51 PM
- richardd8x
December 3, 2018 at 11:51 PM
-
- Replies
- 0
- Views
- 268
-
-
-
-
Complex COUNTIFS? 2
- rinconpaul
February 1, 2018 at 9:21 AM
- rinconpaul
February 1, 2018 at 3:52 PM
-
- Replies
- 2
- Views
- 546
2
-
-
-
-
Pivot Table groups of values 1
- rinconpaul
April 14, 2018 at 1:03 AM
- rinconpaul
April 14, 2018 at 2:49 AM
-
- Replies
- 1
- Views
- 434
1
-
-
-
-
Excel Formula & Dates
- riskier4ra
December 26, 2017 at 8:27 AM
- riskier4ra
December 26, 2017 at 8:27 AM
-
- Replies
- 0
- Views
- 288
-
-
-
-
Using sumproduct to sum values associated with years 8
- riskier4ra
December 30, 2017 at 10:21 PM
- riskier4ra
January 2, 2018 at 10:43 AM
-
- Replies
- 8
- Views
- 1.7k
8
-
-
-
-
Drawdown by ID and Transaction 4
- RiskyBiz
November 7, 2019 at 11:16 PM
- RiskyBiz
November 10, 2019 at 9:06 AM
-
- Replies
- 4
- Views
- 704
4
-
-
-
-
Need Excel 365 formula to sum amounts in colored cells 5
- riyaz
November 1, 2020 at 11:51 AM
- riyaz
November 2, 2020 at 10:13 AM
-
- Replies
- 5
- Views
- 979
5
-
-
-
-
Lookup Multiple Values in a column with the 1 lookup 1
- rjw415
March 17, 2016 at 2:45 PM
- rjw415
March 26, 2016 at 7:34 PM
-
- Replies
- 1
- Views
- 1.3k
1
-