From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Extract the competition winners

Extract the competition winners - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Extract the competition winners

“

- Now we're going into the world of competition reality shows. In column B, we've got the list of shows and in columns C through F, are all of the contestants from each show. Each winner is highlighted in blue. We need a list with the show and next to it, the winner. Just two columns. Season 1, Episode 1, Aurora. Season 1, Episode 2, Tiago. Season 1, Episode 3, Zaqaria, and so forth. And here's one question for you. Why can't you take this straight into power query to deal with it? All right. So, take a deep breath. Pause the video. Get some water. Think about this, work it out. And then, come on back. (video game sounds) Welcome back. Okay. So why can we not take this straight into power query? Because power query will get rid of all of our formatting. Once we get the data into power query, we won't know the winners from the non-winners. So we got to be crafty. Watch what I'm going to do. I'm going to…

Contents