(upbeat electronic music) … - [Instructor] Here's a challenge for you. … We have a music camp, and we need to round out … some slots that are still available. … We've got enough guitarists and drummers, … but there might be some room for some experienced drummers. … We don't know yet. … So we're going to create two lists. … First, list all of the musicians who are not guitarists, … not drummers, and they're first-time applicants. … If there are no musicians that fit those criteria, … have the formula return none. … And have that list start in cell I3. … The second mission. … Because we might, we might not have room for some drummers, … but we would like to have experienced drummers … who haven't been at the camp for awhile. … Starting in cell I19, list all returning drummers … who have not been here in less than five years. … So if there's a drummer who's returning, … but has been here two years ago, … we don't want that person on the list. … Somebody's not been here in 10 years, … that's fine, that's exactly what we want. …
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.