From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,800 courses taught by industry experts.

Filtering lists with AND and OR criteria when using the FILTER function

Filtering lists with AND and OR criteria when using the FILTER function - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Filtering lists with AND and OR criteria when using the FILTER function

“

- [Instructor] Excel's filtering capability gives us a lot of tools for pairing down lists, but it can't meet all of our needs. And sometimes what we also want to do when we filter is to create a new list that's just showing some of the data, the data that we need, based on that original list. And we do that by way of relatively new function in Excel called FILTER, and we're about to use it here in J2. And we've got two different objectives. The first one is anytime the entry in column E, these are the actual sales numbers, either are equal to or meet the Quota in column D, we'd like to find those records and we want to combine that with the need of only doing that for the people who have been here more than nine years of service. At a later time and perhaps in a different location, we might want to do something similar where we're looking for any of these rows where either of those two criteria have been met. If you…

Contents