|
Featured Tutorial
Featured Macro
Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter
Comprehensive Video that shows how to extract records from a table covering these topics:
1. Filter with 6 criteria then extract records to a new location
2. Advanced Filter with 6 criteria then extract records to a new location
3. Array Formula with 6 criteria then extract records to a new location
4. Learn About AND criteria
5. Learn about OR criteria
6. Learn about BETWEEN criteria
7. Learn how to extract records with Date Criteria
8. Learn about Boolean logic to count the number of records that match six criteria and extract the records
9. See the functions; SUMPRODUCT, IF, ROWS, INDEX, SMALL, ROW, AGGREGATE
10. See how to avoid Ctrl + Shift + Enter for an array formula by using the AGGREGATE function.
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
1. Filter with 6 criteria then extract records to a new location
2. Advanced Filter with 6 criteria then extract records to a new location
3. Array Formula with 6 criteria then extract records to a new location
4. Learn About AND criteria
5. Learn about OR criteria
6. Learn about BETWEEN criteria
7. Learn how to extract records with Date Criteria
8. Learn about Boolean logic to count the number of records that match six criteria and extract the records
9. See the functions; SUMPRODUCT, IF, ROWS, INDEX, SMALL, ROW, AGGREGATE
10. See how to avoid Ctrl + Shift + Enter for an array formula by using the AGGREGATE function.
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm