Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Extract text from a string of text based on the range defined 13
- brijeshkeni
-
- Replies
- 13
- Views
- 386
13
-
-
-
-
Cell Value Fill Based on Color 11
- dan_jordan84
-
- Replies
- 11
- Views
- 581
11
-
-
-
-
CountIFS in same row problem 2
- jbanks
-
- Replies
- 2
- Views
- 381
2
-
-
-
-
'tricking' excel to recognise a table header outside of the table 6
- paulbiddis
-
- Replies
- 6
- Views
- 501
6
-
-
-
-
FILTER and UNIQUE - dependent dropdown lists... 19
- paulbiddis
-
- Replies
- 19
- Views
- 659
19
-
-
-
-
Formula for calculating totals for different months in a list as a percentage? 7
- Smudge.Smith
-
- Replies
- 7
- Views
- 238
7
-
-
-
-
EXCEL FORMULA 9
- beealf
-
- Replies
- 9
- Views
- 545
9
-
-
-
-
Nested IF ANDs 5
- Sper434
-
- Replies
- 5
- Views
- 225
5
-
-
-
-
INDIRECT function does not work when referencing to a dynamic list 10
- paulbiddis
-
- Replies
- 10
- Views
- 387
10
-
-
-
-
Combining Monthly Fee Totals by month, year, and location with Annual Fee Increases 14
- Retailmessiah
-
- Replies
- 14
- Views
- 710
14
-
-
-
-
Count number of cells with more than 3 charactors 4
- jbanks
-
- Replies
- 4
- Views
- 248
4
-
-
-
-
data array with date range and return text value in result 4
- jigarecity
-
- Replies
- 4
- Views
- 196
4
-
-
-
-
Sum of chosen cells based on searched criteria? Countifs? Sumif? SumProduct? 2
- jbanks
-
- Replies
- 2
- Views
- 153
2
-
-
-
-
Sum across worksheets while ignoring hidden worksheets 13
- mike_calc
-
- Replies
- 13
- Views
- 473
13
-
-
-
-
Need Help ASAP with this formula 3
- overrated
-
- Replies
- 3
- Views
- 181
3
-
-
-
-
How to update a cell when new data is entered 5
- fi1808
-
- Replies
- 5
- Views
- 402
5
-
-
-
-
find a match using vlookup (but not just first entry) 1
- POQUACK
-
- Replies
- 1
- Views
- 121
1
-
-
-
-
Auto-copy formating of cells 7
- digitalricho
-
- Replies
- 7
- Views
- 428
7
-
-
-
-
Please help for create formula using Isnumber, search and vlookup or index. 3
- ansh2792
-
- Replies
- 3
- Views
- 704
3
-
-
-
-
INDEX MATCH of Two Lookup_Array 1
- IEXCELMYWORK
-
- Replies
- 1
- Views
- 160
1
-