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.

Universal pizza toppings

Universal pizza toppings - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Universal pizza toppings

“

- [Instructor] These five friends got together, decided, hey, let's order a pizza. And then a feud commenced because they couldn't agree on the toppings. One of them is an Excel expert and said, look, how about we put all of our preferences into a spreadsheet and then we decide the pizza toppings will be what all five of us like. Pretty clever. Could turn out to be kind of nasty, but they're willing to take the risk. Let's look at the data. Let's look at pepperoni. Only three people like pepperoni, so that's not going to be a topping. How about minced garlic? Only two people like that. Again, off the list. Now it's your turn to pause the video, figure out which toppings all five friends like, and while you're at it, order yourself a pizza. You ready to do it? Let's get on with it. Equals TOCOL, double-click it. What's the array? This array, comma, yes, ignore blanks. Put in a one and then Enter. There…

Contents