From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Meeting unusual filtering needs via Advanced Filter

Meeting unusual filtering needs via Advanced Filter - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Meeting unusual filtering needs via Advanced Filter

“

- [Instructor] Excel users who work with lists are not doubt familiar with one of Excel's most important data management tools found on the Data tab. It's called Filter. And if you were working with this list, you might use the filter to show just the products refrigerators and washers, or possibly data out of a certain region, or maybe just focused on a certain person, or even combinations of those. But there's certain kinds of constructions you can't get to with a standard filter. For example, suppose we wanted to find all rows where the product is dryers or the customer is Home USA. In other words, we'd like to see both of these rows here. And anytime we see either one of those or both, we want to see that row. Now admittedly, that's an unusual kind of construction, but we cannot do that with a standard filter. And something else we can't do either, we can't look at the data here by day of the week. So if you were to…

Contents