- [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. …
AuthorOz du Soleil
- Working with spills
- Using the UNIQUE function
- Sorting with dynamic arrays
- Comparing SORTBY and SORT
- Unstacking records with SEQUENCE
- Creating intelligent filters
- Randomizing data with RANDARRAY
- Combining dynamic arrays in drop lists and more
Skill Level Advanced
1. What to Know Before Using the New Functions
Warnings to heed6m 19s
Horizontal SORT3m 33s
9. Putting It All Together
10. Challenges and Solutions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.