Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Sum across worksheets while ignoring hidden worksheets 13
- mike_calc
January 26, 2021 at 4:02 PM
- mike_calc
January 27, 2021 at 2:28 PM
-
- Replies
- 13
- Views
- 1.6k
13
-
-
-
-
Indirect/substitute formula help 13
- freddie0
April 3, 2020 at 7:07 PM
- freddie0
April 22, 2020 at 1:53 PM
-
- Replies
- 13
- Views
- 5.6k
13
-
-
-
-
Converting Date to text add 1 Week 13
- Billyrj
April 1, 2020 at 1:27 AM
- Billyrj
April 1, 2020 at 11:27 AM
-
- Replies
- 13
- Views
- 1.7k
13
-
-
-
-
Dropdown selection based on previous dropdown selection 13
- DezB
April 3, 2019 at 11:53 AM
- DezB
April 10, 2019 at 9:39 AM
-
- Replies
- 13
- Views
- 1.7k
13
-
-
-
-
Excel 2007 conjugate of column data 13
- Ronbro2018
October 31, 2018 at 6:00 PM
- Ronbro2018
November 3, 2018 at 10:24 PM
-
- Replies
- 13
- Views
- 1.4k
13
-
-
-
-
Autopopulate Cells when meeting 3 conditions 13
- marcelkahn5
September 1, 2018 at 7:31 PM
- marcelkahn5
September 6, 2018 at 8:41 PM
-
- Replies
- 13
- Views
- 1.3k
13
-
-
-
-
Dashboard formula 13
- peter renton
February 21, 2018 at 11:09 AM
- peter renton
February 26, 2018 at 12:58 PM
-
- Replies
- 13
- Views
- 1.7k
13
-
-
-
-
Random selection depending on Criteria 13
- Jazper36
February 1, 2018 at 6:20 PM
- Jazper36
February 6, 2018 at 2:13 PM
-
- Replies
- 13
- Views
- 1.2k
13
-
-
-
-
Sum Area Based on Compound Row and Column Criteria 13
- DC Mega
January 14, 2018 at 12:47 PM
- DC Mega
September 18, 2018 at 6:59 AM
-
- Replies
- 13
- Views
- 2.4k
13
-
-
-
-
Conditional format formula 13
- jl2509
December 14, 2017 at 10:02 AM
- jl2509
December 14, 2017 at 4:26 PM
-
- Replies
- 13
- Views
- 929
13
-
-
-
-
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
-
-
-
-
DIV/0 Error when dividing 0.00%'s 13
- DezB
August 11, 2017 at 8:44 AM
- DezB
August 11, 2017 at 9:28 AM
-
- Replies
- 13
- Views
- 1.7k
13
-
-
-
-
Sorting by phone #, phone # in different columns, phone # with extentions 13
- FlailingEnginer
July 14, 2017 at 8:46 PM
- FlailingEnginer
July 19, 2017 at 9:35 PM
-
- Replies
- 13
- Views
- 1.8k
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
-
-
-
-
"tilde" in vlookup formula 13
- Anri
March 22, 2017 at 5:42 AM
- Anri
March 22, 2017 at 2:04 PM
-
- Replies
- 13
- Views
- 4k
13
-
-
-
-
Subtracting time depending on text in a previous cell 13
- CaulfieldS
January 17, 2017 at 4:50 PM
- CaulfieldS
January 17, 2017 at 6:01 PM
-
- Replies
- 13
- Views
- 1.9k
13
-
-
-
-
Copy rows from one sheet to another based on match 12
- Smudge.Smith
January 9, 2023 at 3:31 PM
- Smudge.Smith
February 1, 2023 at 5:59 AM
-
- Replies
- 12
- Views
- 1.7k
12
-
-
-
-
Returning 10 largest values when looking up in a list! 12
- cambos444
August 19, 2021 at 11:27 AM
- cambos444
August 19, 2021 at 6:56 PM
-
- Replies
- 12
- Views
- 1.3k
12
-
-
-
-
Display data from one tab as merged cells on another tab of workbook 12
- ajrilo1
February 19, 2021 at 2:25 PM
- ajrilo1
February 23, 2021 at 2:59 PM
-
- Replies
- 12
- Views
- 2.1k
12
-
-
-
-
Finding the Median for certain dates from a list of data 12
- moyad612013
May 11, 2020 at 8:37 PM
- moyad612013
May 15, 2020 at 1:11 PM
-
- Replies
- 12
- Views
- 3.5k
12
-