Sample file: How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel
This is the demonstration file to accompany the article, How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel, by Susan Harkins.
From the introduction of this Microsoft Excel tutorial:
Applying multiple criteria against different columns to filter the data set in Microsoft Excel sounds difficult but it really isn’t as hard as it sounds. The most important part is to get the logic between those columns right. For instance, do you want to see all records where one column equals x and another equals y? Or you might want to see all records where one column = x or another column equals y. The results will be very different. In this article, I’ll show you how to include AND and OR operations in Excel’s FILTER() function.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays