From the course: Excel: Using Dynamic Array Functions (Microsoft 365)

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

FILTER logic: Asterisk

FILTER logic: Asterisk

From the course: Excel: Using Dynamic Array Functions (Microsoft 365)

Start my 1-month free trial

FILTER logic: Asterisk

“

- [Instructor] Filtering with an asterisk as our operator means that we want both criteria. Here we've got venues and information about whether they have Wi-Fi or not, their capacity, and if they have a projector. We'd like to filter the venues for those that have Wi-Fi and have a minimum capacity of 30 because we're going to have an Excel workshop and we need enough room. Let's filter. Let's grab this cell here, equals filter. Open parentheses. The array we want is this entire range. Comma, what do we want to include? Our first criteria is for Wi-Fi. Open parentheses. Highlight the Wi-Fi range. Equals yes and we have to put that in double quotes. Close parentheses. Now our asterisk for and. Open parentheses and our next criteria, a minimum capacity of 30. Highlight the capacity column and we want greater than or equal to 30. Close parentheses and then close parentheses again to close off the function, press enter. There we go. Xinnia's has Wi-Fi and it has a capacity of 40, well…

Contents