Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Conditional Formatting: Trouble adding a col qualifier value into an existing formula 13
- wittonline
September 7, 2017 at 7:46 PM
- wittonline
September 12, 2017 at 1:18 PM
-
- Replies
- 13
- Views
- 1.9k
13
-
-
-
-
MODE MATCH Formula (for most common occurance) not considering entire range 13
- wittonline
May 9, 2017 at 12:14 PM
- wittonline
May 26, 2017 at 8:20 PM
-
- Replies
- 13
- Views
- 2k
13
-
-
-
-
Trying to get AVE &SUM, considering code in the calcs; not dependent on specific cols 1
- wittonline
April 24, 2017 at 5:46 PM
- wittonline
April 25, 2017 at 2:08 AM
-
- Replies
- 1
- Views
- 656
1
-
-
-
-
Trying to understand cell formulas when extra characters used, learn to SUM and AVE 9
- wittonline
April 17, 2017 at 3:17 AM
- wittonline
April 21, 2017 at 7:10 PM
-
- Replies
- 9
- Views
- 1.5k
9
-
-
-
-
Stop Vlookup returning 0 2
- Winwhite
January 6, 2017 at 2:59 PM
- Winwhite
January 6, 2017 at 5:03 PM
-
- Replies
- 2
- Views
- 1.3k
2
-
-
-
-
UDF in a Userform 3
- wings
September 9, 2021 at 3:40 AM
- wings
September 9, 2021 at 8:58 AM
-
- Replies
- 3
- Views
- 405
3
-
-
-
-
Retrieve data from last row / cell in Dynamic Range 1
- WillAnt
April 20, 2020 at 2:36 PM
- WillAnt
April 20, 2020 at 4:25 PM
-
- Replies
- 1
- Views
- 2.2k
1
-
-
-
-
Last cell containing data in Dynamic Range 1
- WillAnt
April 17, 2020 at 1:47 PM
- WillAnt
April 17, 2020 at 4:17 PM
-
- Replies
- 1
- Views
- 733
1
-
-
-
-
Integrate Formula into VLOOKUP 9
- WillAnt
September 30, 2018 at 5:36 PM
- WillAnt
October 1, 2018 at 5:59 PM
-
- Replies
- 9
- Views
- 1.3k
9
-
-
-
-
Return Header Data for first consecutive cell 1
- wildus
August 21, 2018 at 10:10 PM
- wildus
August 25, 2018 at 6:55 PM
-
- Replies
- 1
- Views
- 287
1
-
-
-
-
IFS function giving #NAME? error 1
- wildeye
November 28, 2017 at 7:37 AM
- wildeye
November 28, 2017 at 12:51 PM
-
- Replies
- 1
- Views
- 1.2k
1
-
-
-
-
discount codes 1
- whatisVBA
March 30, 2016 at 8:39 PM
- whatisVBA
March 31, 2016 at 6:57 AM
-
- Replies
- 1
- Views
- 990
1
-
-
-
-
Use a cell as reference to sheet to look in 1
- wes2706
October 11, 2017 at 3:38 PM
- wes2706
October 12, 2017 at 3:57 AM
-
- Replies
- 1
- Views
- 458
1
-
-
-
-
Conditional Formatting based on another cell having data 6
- WendleB
September 28, 2018 at 2:31 PM
- WendleB
October 5, 2018 at 4:33 PM
-
- Replies
- 6
- Views
- 525
6
-
-
-
-
Extract text string 5
- Webbers
June 7, 2019 at 9:58 PM
- Webbers
June 28, 2019 at 6:31 PM
-
- Replies
- 5
- Views
- 974
5
-
-
-
-
Count with multiple criteria including a date plus an "or" variable 3
- Webbers
April 3, 2019 at 11:51 PM
- Webbers
April 5, 2019 at 6:40 PM
-
- Replies
- 3
- Views
- 712
3
-
-
-
-
Gantt Chart - Data Bars not all correct color for each project 10
- Webbers
February 22, 2019 at 5:15 PM
- Webbers
March 7, 2019 at 7:53 PM
-
- Replies
- 10
- Views
- 1.7k
10
-
-
-
-
Search Multiple Ranges for Keywords within Text Strings 4
- Webbers
February 13, 2019 at 9:24 PM
- Webbers
February 14, 2019 at 6:17 PM
-
- Replies
- 4
- Views
- 680
4
-
-
-
-
If statement 10
- waterscapes
April 1, 2021 at 11:29 PM
- waterscapes
April 21, 2021 at 8:01 PM
-
- Replies
- 10
- Views
- 1.2k
10
-
-
-
-
Calculate Holidays with Networkdays 1
- Wasiq
January 10, 2017 at 7:07 AM
- Wasiq
January 11, 2017 at 7:54 AM
-
- Replies
- 1
- Views
- 973
1
-