(upbeat music playing) … - [Oz] Welcome back. … I hope you got that. … If you didn't, that's fine, I'm going to take you through this. … First, I always put my data into a table. … Inside of data range, format as table, … I'm going to grab this nice blue. … Okay, the table does have headers. … And I'm going to get rid of these filter buttons. … Next, I'm going to move this box out of the way. … So that we can see. … Alright. … We want all musicians who are not guitarists, not drummers, … their first time. … Okay. … Equals, filter. … Filter what? … I'm going to open parentheses, filter our array. … We want just these four columns. … Since we're looking for people who are first time, … we don't need the last attendance column. … That's our array. … Comma, include what? … Our first criteria. … Open parentheses, let's grab our first timers. … Highlight this column for application. … Equals, in parentheses, first time. … Double quote, close parentheses. … That's our first criteria. … Next criteria, people who are not guitarists. …
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.