CODEWITHSUNDEEP
excelduplicatesexcel-formula
Ryan
Ryan

Reputation: 15270

How can I display unique names in Excel?

Given the following table on sheet one:

Name
-------
Alan
Barb
Corey
Barb
Alan
Daniel
Alan

How can I generate the following table on sheet two?

Name
-------
Alan
Barb
Corey
Daniel

I cannot leave empty rows like this:

Name
-------
Alan
Barb
Corey


Daniel

Upvotes: 1

Views: 4091

Answers (3)

andy holaday
andy holaday

Reputation: 2302

There is a formulaic approach that is not version-dependent. See Oscar's Site.

Upvotes: 2

rajah9
rajah9

Reputation: 12339

I'm assuming you have Excel 2007 or later.

Copy the entire list, duplicates and all, to Sheet 2.

Then go to the Data tab. In the Data tools section there is a large button called "Remove Duplicates." It will do just that.

Upvotes: 2

vergenzt
vergenzt

Reputation: 10367

As far as I know, there is no way to do it formulaically.

If you just need a one-time copy, though, this article explains how to do it.

Upvotes: 0

Related Questions