Excel Forum

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.