Excel Forum
Similar Content
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Filter and Sort Data on Charts in Excel
Tutorial: Create a dynamic chart in Excel that displays only the data you want. You can filter it an...
Display the AutoFilter Criteria Applied to a Data Set in a Cell in Excel - UDF
Macro: This free Excel UDF (user defined function) allows you display the filter criteria tha...
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 760: OR AND AND Logical Test To Extract Data With Formula Or Advanced Filter


Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to extract data from a table of data with complex criteria using OR AND AND functions. See how to do it with a non-array formula and with Advanced Filter. See the functions OR, AND, SUM, IF, VLOOKUP and COLUMNS. For Advanced Filter, learn that AND criteria goes on the same row and OR criteria goes on different rows.
Also see these videos:
Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods
Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions





Got a Question? Ask it Here in the Forum.