From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,000 courses taught by industry experts.

FILTER

FILTER

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

FILTER

“

- [Instructor] The filter function, this is exciting. Look at this. We have vacation packages, we have the destination, the days, and whether they're international or not. And you can see, vacation eight is a beach vacation that's 15 days and it is not international. So, let's use the filter function to filter for vacation packages that are not the beach. Equals filter open parenthesis the array. What do I want to filter? Let's filter for the entire table's worth of data. Comma, include. Include where the destination does not equal beach. Double quote, close parenthesis, and enter. Okay, got to widen this so we can see. All right. And then I'm going to center these. Good. We don't have vacation package one or three because they are the beach. Check that out. We have only the vacation packages that are not the beach. And in order to get rid of this, we only have one formula to delete. Gone. Now, let's filter for…

Contents