Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Large function with criteria. 2
- digitalricho
January 15, 2021 at 7:08 AM
- digitalricho
January 15, 2021 at 9:35 AM
-
- Replies
- 2
- Views
- 1k
2
-
-
-
-
INDEX MATCH of Two Lookup_Array 1
- IEXCELMYWORK
January 17, 2021 at 9:35 AM
- IEXCELMYWORK
January 17, 2021 at 11:13 AM
-
- Replies
- 1
- Views
- 499
1
-
-
-
-
Please help for create formula using Isnumber, search and vlookup or index. 3
- ansh2792
January 17, 2021 at 10:05 AM
- ansh2792
January 18, 2021 at 3:05 PM
-
- Replies
- 3
- Views
- 1.3k
3
-
-
-
-
Formula To Calculate Accrued Time With Variables 2
- JMAN
January 14, 2021 at 3:36 PM
- JMAN
January 19, 2021 at 3:04 PM
-
- Replies
- 2
- Views
- 591
2
-
-
-
-
find a match using vlookup (but not just first entry) 1
- POQUACK
January 21, 2021 at 3:51 PM
- POQUACK
January 21, 2021 at 4:17 PM
-
- Replies
- 1
- Views
- 401
1
-
-
-
-
How to update a cell when new data is entered 5
- fi1808
January 22, 2021 at 4:58 AM
- fi1808
January 22, 2021 at 1:38 PM
-
- Replies
- 5
- Views
- 869
5
-
-
-
-
Auto-copy formating of cells 7
- digitalricho
January 20, 2021 at 5:50 PM
- digitalricho
January 23, 2021 at 6:28 AM
-
- Replies
- 7
- Views
- 1.2k
7
-
-
-
-
Need Help ASAP with this formula 3
- overrated
January 26, 2021 at 12:22 AM
- overrated
January 27, 2021 at 6:27 AM
-
- Replies
- 3
- Views
- 511
3
-
-
-
-
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
-
-
-
-
Sum of chosen cells based on searched criteria? Countifs? Sumif? SumProduct? 2
- jbanks
January 27, 2021 at 10:44 AM
- jbanks
January 27, 2021 at 7:31 PM
-
- Replies
- 2
- Views
- 500
2
-
-
-
-
data array with date range and return text value in result 4
- jigarecity
January 27, 2021 at 1:33 PM
- jigarecity
January 28, 2021 at 9:21 AM
-
- Replies
- 4
- Views
- 646
4
-
-
-
-
Conditional formatting formula to highlight alternate groupings of duplicate dates 1
- abaker77
November 26, 2020 at 6:28 PM
- abaker77
January 29, 2021 at 5:13 PM
-
- Replies
- 1
- Views
- 876
1
-
-
-
-
Count number of cells with more than 3 charactors 4
- jbanks
January 27, 2021 at 7:37 PM
- jbanks
January 30, 2021 at 7:40 PM
-
- Replies
- 4
- Views
- 795
4
-
-
-
-
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.8k
14
-
-
-
-
Nested IF ANDs 5
- Sper434
February 1, 2021 at 6:54 PM
- Sper434
February 2, 2021 at 7:16 AM
-
- Replies
- 5
- Views
- 706
5
-
-
-
-
INDIRECT function does not work when referencing to a dynamic list 10
- paulbiddis
January 31, 2021 at 12:22 PM
- paulbiddis
February 2, 2021 at 3:24 PM
-
- Replies
- 10
- Views
- 1.4k
10
-
-
-
-
EXCEL FORMULA 9
- beealf
February 2, 2021 at 2:02 PM
- beealf
February 4, 2021 at 7:31 AM
-
- Replies
- 9
- Views
- 1.4k
9
-
-
-
-
calculate average of dates 3
- NormanW
November 20, 2020 at 3:45 PM
- NormanW
February 5, 2021 at 1:46 PM
-
- Replies
- 3
- Views
- 1.2k
3
-
-
-
-
Formula for calculating totals for different months in a list as a percentage? 7
- Smudge.Smith
February 5, 2021 at 3:20 PM
- Smudge.Smith
February 6, 2021 at 8:17 AM
-
- Replies
- 7
- Views
- 1.1k
7
-
-
-
-
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
-