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 3: Assignment

Challenge 3: Assignment

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Challenge 3: Assignment

“

(energetic music) - [Teacher] Now this challenge. Wow, you got to really think about this one, alright? We have the pairs of people who've been assigned shifts. Cheryl and Martin are assigned the afternoon of day two. We've got Mars and Ariel the evening of day four, and Cheryl and Daniel morning of day six. Our goal, get a list of anybody that has only one shift. We do see two Todds. We see a number of Noonis, et cetera. So please, use what you know. All of the skills that you learned in the course to get a list of people who are in this dataset just one time. Pause the video. Work that out. (lively music) Okay, here we go. Wow, alright. First of all, I'm going to take a deep breath. Okay. I'm going to go right here to this cell equals TOCOL. Double click it. Am I startin' the way that you started? If we started different ways, it doesn't matter as long as we wind up with the right answer and that you…

Contents