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

Unlock the full course today

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

FILTER Logic: Greater Than

FILTER Logic: Greater Than

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

Start my 1-month free trial

FILTER Logic: Greater Than

“

- [Instructor] When we're using a filter function and want to filter for two criteria, one operator we have available to us is the greater-than symbol. And what that'll bring back for us is all Xs that are not also Y. Looking at this data we have Item IDs, Category, Statuses and Counts. We'd like to know which Automotive items are not discontinued. We want to dig out the Automotives that are available, low, and out of stock. So, let's do it. Equals filter. Okay, our array. We got the black arrow above our table, highlight the entire table. Comma. Include means our criteria that we want. Our first criteria is we want the category of Automotive. Open parenthesis. Grab our category column. Equals, and we're going to select automotive here in I2. Close parenthesis. Now the greater-than symbol. Open parenthesis, and our second criteria. Status column equals discontinued. Close parenthesis, comma, and what if there is no result. Put none in double quotes. Close parenthesis, enter. There are…

Contents