From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Who's on all three lists?

Who's on all three lists? - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Who's on all three lists?

“

- [Instructor] We've got three different lists. I'm going to click inside this table. Notice we are on the Monday sheet. I'm going to go to Table Design, and I have named the table Monday. Let's go to Thursday. Click inside the table, and notice Table Design says Thursday. Next, look at Friday's list, everybody who's attended. Click inside the table. It is named Friday. Let's go back to the start. We've got six people. Esme, Fish, Heloisa, Ike, Maggie, and Otis were supposed to have attended all three sessions. Did they? That's the question. There are a lot of ways to accomplish this. Pick whatever you're comfortable with, except for eyeballing and flipping around back and forth. Don't do that. All right. Figure out if these six people attended all three sessions. Come back, and I'll go through it. Let's dive in, but let me show you something first. I could use equals match, open parentheses, and then the…

Contents