From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Find any duplicate or missing names

Find any duplicate or missing names - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Find any duplicate or missing names

“

- [Instructor] Here is a list of names in our source data. Everybody was supposed to have been assigned to a group and we need to check has anybody been replicated? Meaning is anybody assigned to more than one group and are there any duplicate names within a group? And we're only concerned about the source data. And let's look at it. Here's group A, group B, and notice in group B, there is last name, comma, first name. And for a couple of people, there's even a middle initial. And then let's look at group C. Yes, there are extra names in here, like Ana H. Rosetta. We're not concerned about those names. We're only concerned about the names in the source list. And here's one example that tipped me off that something's wrong. Niam Cabrera is here. Go over to group A, Niam Cabrera is here. And go back to the source, yes, Niam Cabrera is one in our source list. To summarize the objectives: identify any replicated…

Contents