How to Remove Duplicates from a List

[RickGreg]

I have a long list of email addresses in a column, many of which are
duplicated. I have come up with a few multi-step ways to de-dupe the list,
but figure there must be a more elegant approach. Excel help was no help.

 

[JE McGimpsey]

I have a long list of email addresses in a column, many of which are
duplicated. I have come up with a few multi-step ways to de-dupe the list,
but figure there must be a more elegant approach. Excel help was no help.

Take a look here:

http://cpearson.com/excel/deleting.htm#DeleteDuplicateRows

 

[RickGreg]

Take a look here:

http://cpearson.com/excel/deleting.htm#DeleteDuplicateRows

Perfect. Thank you!

 

[Salmon Egg]

I have a long list of email addresses in a column, many of which are
duplicated. I have come up with a few multi-step ways to de-dupe the list,
but figure there must be a more elegant approach. Excel help was no help.

What I do is the following:

Say the list is in column A. In column B I put =A[R,C]=A[R-1,C]. I do not
use this notation often so the formula may not be exactly correct.

I copy column B and paste special value back to B.

I sort on B. This gathers all the TRUEs and FALSEs together.

Then I delete the multiple entries.

You can also then delete column B.

Bill
-- Ferme le Bush