From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Filter venues with dynamic arrays

Filter venues with dynamic arrays - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Filter venues with dynamic arrays

“

- [Instructor] All right, this is exciting. We're going into dynamic array land, all right? We are planning an event. We have a list of possible venues, and your help is needed in this way. In cell G6, write a dynamic array filter formula that will filter for venues with a minimum capacity that's in H2, and a cost that's less than the value in H3. And if no venues fit that criteria, then have the formula return none. Once you've got that, then test it by changing the capacity and the cost amounts, then make sure that filter updates, all right? Pause the video, make the filter, come back, and I'll show you how I do it. Okay, let's make that filter formula. Equals, filter, one more double-click here. What's the array? Here it is. Comma, include what? Since we're going to have two criteria, I'm going to open a parentheses right here. First criteria, where the capacity is greater than or equal to the value here.…

Contents