Solution 2

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