Find the most popular product combinations in Excel - Microsoft Excel Tutorial

(electronic music) - I'm here at my pizza shop, and my brother, Moses, keeps callin' me, talkin' about a habanero pepper, anchovy, ham pizza. Because we are thinkin' about serving slices at night for the late night crowd. Which one should we have prepared for 'em? (electronic music) I'm not seeing habanero, ham, anchovies. That sounds kind of nasty, but I've got data of the pizzas that have been ordered, their toppings, and we can look at it to see which are the most popular and who has ever ordered this Moses special of habanero pepper, anchovy, ham. Before we get started to answer the question about which are the top three toppings and get back to Moses about some reality, we need all the combinations. So, here, I've got a list of over 200 pizzas that have been ordered. To get all of the possible combinations, I suggest going to any one of many websites online that do permutations and combinations, and when you put that into the website, you want no repeats and no, order is not…