- [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. …
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.