Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Return Specific Value from adjacent cell if values match 5
- JadeRae
May 11, 2016 at 8:53 PM
- JadeRae
May 11, 2016 at 10:54 PM
-
- Replies
- 5
- Views
- 2.8k
5
-
-
-
-
Sumifs to sum qty's from 3 different columns with same criteria 19
- Freddyfroo
July 5, 2017 at 9:08 AM
- Freddyfroo
July 5, 2017 at 3:23 PM
-
- Replies
- 19
- Views
- 2.8k
19
-
-
-
-
What is the average overall letter grade? 4
- DrRandyman
November 3, 2020 at 12:16 PM
- DrRandyman
November 4, 2020 at 4:26 PM
-
- Replies
- 4
- Views
- 2.8k
4
-
-
-
-
Clear cell range without using VBA/Macro 4
- kmsafstrom
March 5, 2021 at 4:31 AM
- kmsafstrom
March 9, 2021 at 2:22 PM
-
- Replies
- 4
- Views
- 2.7k
4
-
-
-
-
Dependent dropdown lists with multiple words in the different sheets 17
- onexc
March 22, 2021 at 5:12 PM
- onexc
March 26, 2021 at 3:59 PM
-
- Replies
- 17
- Views
- 2.7k
17
-
-
-
-
Use last value in a column, increment it by 1 and start a new column with this value. If value>x, then start the count in this column, from 1 11
- leema
May 24, 2020 at 9:26 AM
- leema
May 25, 2020 at 9:57 PM
-
- Replies
- 11
- Views
- 2.7k
11
-
-
-
-
Formula find max value for multiple if thens.. between: ">" or "<" and a "," 11
- davex
May 23, 2017 at 10:28 PM
- davex
May 27, 2017 at 4:12 AM
-
- Replies
- 11
- Views
- 2.7k
11
-
-
-
-
Double counting in SUMPRODUCT formula 11
- Luis Ah-Hoy Jr.
March 15, 2017 at 10:54 AM
- Luis Ah-Hoy Jr.
March 16, 2017 at 7:25 AM
-
- Replies
- 11
- Views
- 2.6k
11
-
-
-
-
Auto Fill Down Number List 11
- luarbiasa
April 3, 2016 at 1:48 AM
- luarbiasa
April 12, 2016 at 10:10 AM
-
- Replies
- 11
- Views
- 2.6k
11
-
-
-
-
FILTER and UNIQUE - dependent dropdown lists... 19
- paulbiddis
February 5, 2021 at 6:01 PM
- paulbiddis
February 9, 2021 at 12:48 PM
-
- Replies
- 19
- Views
- 2.6k
19
-
-
-
-
Replace a row number with a dynamic cell value 3
- acat
May 15, 2019 at 9:55 PM
- acat
May 17, 2019 at 5:40 PM
-
- Replies
- 3
- Views
- 2.6k
3
-
-
-
-
YTD using dynamic spilled array 11
- MatthewHart
December 12, 2019 at 12:56 PM
- MatthewHart
December 14, 2019 at 11:46 AM
-
- Replies
- 11
- Views
- 2.6k
11
-
-
-
-
Trying to generate actual selling day of current month and current year 6
- dvswindler
March 10, 2016 at 9:02 PM
- dvswindler
March 12, 2016 at 8:23 PM
-
- Replies
- 6
- Views
- 2.6k
6
-
-
-
-
Need Help with Resetting a Countif Function 6
- BDGibson4
August 26, 2020 at 10:45 AM
- BDGibson4
August 26, 2020 at 12:55 PM
-
- Replies
- 6
- Views
- 2.6k
6
-
-
-
-
COUNTIF Problem 16
- endl3ss
August 17, 2016 at 9:45 PM
- endl3ss
August 19, 2016 at 6:50 AM
-
- Replies
- 16
- Views
- 2.6k
16
-
-
-
-
Sum numbers in a single cell 7
- chxjett
November 2, 2016 at 8:17 PM
- chxjett
November 7, 2016 at 3:58 PM
-
- Replies
- 7
- Views
- 2.6k
7
-
-
-
-
alert levels 12
- zohar
January 30, 2020 at 3:47 AM
- zohar
February 5, 2020 at 4:33 AM
-
- Replies
- 12
- Views
- 2.6k
12
-
-
-
-
Highlight largest value cell in range based on other columns 15
- paul789
April 2, 2017 at 10:16 AM
- paul789
April 3, 2017 at 1:42 PM
-
- Replies
- 15
- Views
- 2.6k
15
-
-
-
-
Excel Formula Sum of Minimum Values 10
- GIRISHBISHT
April 12, 2016 at 8:55 AM
- GIRISHBISHT
April 12, 2016 at 10:49 AM
-
- Replies
- 10
- Views
- 2.5k
10
-
-
-
-
IFERROR VLOOKUP MAX value 8
- ItsSugarBunny
July 31, 2018 at 1:34 PM
- ItsSugarBunny
August 9, 2018 at 3:28 PM
-
- Replies
- 8
- Views
- 2.5k
8
-