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.
Challenge 2
From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Challenge 2
(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. And if…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.