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.

Parse and summarize data to tally votes

Parse and summarize data to tally votes - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Parse and summarize data to tally votes

“

- [Instructor] Let's dive onto this because I am going to show you two solutions, okay? Here's what's needed. We need a vote count, for each of the colors. See, we've got the color names, in column B, the colors in C, and then we want to fill in that vote count in column D. And here are the votes. In Column G, everybody had to vote for three colors. Alfonse voted for two, which is coral, eight, which is chocolate, one, which is maroon. The order does not matter. What we want is, a count of each vote. How many times was maroon voted for? How many times was violet voted for? Okay, so you've got to peel this data set apart, and then get some summaries. So go ahead, do that, pause the video, figure out which color came out on top, come back, and I will show you two solutions. Okay, let's see if your answer matches mine. Here is solution one, this is the ugly, messy way, but it'll get an answer. Let's move this box out of…

Contents