Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Identify records based on multiple conditions & single occurance of value 8
- ambquinn
-
- Replies
- 8
- Views
- 1.5k
8
-
-
-
-
SUMIF Totals based on multiple critertia 7
- amanda0210
-
- Replies
- 7
- Views
- 1.2k
7
-
-
-
-
using INDIRECT to set structured table reference in formula and return COUNTIF result based on another column value 2
- alz1
-
- Replies
- 2
- Views
- 437
2
-
-
-
-
VLookup to closed workbook 7
- alring
-
- Replies
- 7
- Views
- 340
7
-
-
-
-
Formula to match multiple unique value's
- Alphacino
- Alphacino
-
- Replies
- 0
- Views
- 220
-
-
-
-
Counting Baseball Series 9
- Alix James
-
- Replies
- 9
- Views
- 618
9
-
-
-
-
Reverse Search 2
- alibaba
-
- Replies
- 2
- Views
- 913
2
-
-
-
-
displaying values from a number of worksheets 2
- alibaba
-
- Replies
- 2
- Views
- 794
2
-
-
-
-
Displaying value according to selected data 1
- alibaba
-
- Replies
- 1
- Views
- 547
1
-
-
-
-
get data contains big and small letter and number 3
- alhagag
-
- Replies
- 3
- Views
- 654
3
-
-
-
-
COUNTIF - First char is S, Second can be any number, but not a letter 2
- alfadaz
-
- Replies
- 2
- Views
- 325
2
-
-
-
-
Sum of a column and column total showing different results 3
- alfadaz
-
- Replies
- 3
- Views
- 575
3
-
-
-
-
Finding the earliest date/time when all tests parameters meet their respective targets (pass) 2
- alex_a
-
- Replies
- 2
- Views
- 620
2
-
-
-
-
Need help with the lab test result cloese to 24 hours
- alex_a
-
- Replies
- 0
- Views
- 219
-
-
-
-
Split data from date range to Financial year buckets
- Aleem
-
- Replies
- 0
- Views
- 422
-
-
-
-
SUMPRODUCT over dynamic range - No VBA 1
- al4xms
-
- Replies
- 1
- Views
- 865
1
-
-
-
-
Xlookup with duplicate values in return array 3
- Aksaunder
-
- Replies
- 3
- Views
- 4k
3
-
-
-
-
Mapping in Excel 2
- akovachki
-
- Replies
- 2
- Views
- 484
2
-
-
-
-
sum(sumifs... 2
- akbarnikain
-
- Replies
- 2
- Views
- 393
2
-
-
-
-
Application.WorksheetFuntion.SumIfs 1
- akbarnikain
-
- Replies
- 1
- Views
- 311
1
-