From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Challenge 4: Course order

Challenge 4: Course order

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Challenge 4: Course order

“

(modern techy music) - [Instructor] Okay now. Challenge number four, use the filter function to get a list of the names of the reps who took their courses out of order. Look at Seth. Seth took course one in June and then course two, okay, course two was taken in April actually. So that was the first one. And then course three was completed in August. So Seth is one who did take the courses out of order. So the goal, figure out who took 'em out of order, and then get that list of the names. (modern jazzy beat) Okay, you ready? Let's do this. Here's how I'm going to do this, equals this value greater than this value enter. And then I'm going to drag this field handle over and then send it down. Now, slide that out of the way and get the list of names, equals, filter. Open parentheses. I want to filter the list of names, comma, to include what? Open parentheses where this column equals false. And I don't need the…

Contents