Excel Forum



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





Got a Question? Ask it Here in the Forum.