Excel Forum
Similar Content
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
How to Use Multiple Functions and Formulas in a Single Cell in Excel
Tutorial: Lets learn how to put multiple functions and formulas in a single cell in Excel in order t...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.