Excel remove duplicates

[camidon]

I have a column of data in Excel that is a list of e-mail addresses. The problem is that many of them are duplicates. I would like to know if there is a way to get rid of all of the duplicates in the list.

Thank you,

Chris

 

[patriciaanne]

The easiest way is to select the data and then go to Data>Filter>Advanced Filter. Have it filter in place which is the default and down the bottom of the dialog box, click on unique records only. Click Ok and only unique records will appear.
Patricia

 

[camidon]

Thank you,

That worked great!

Chris

 

[voorkey]

Patricia,
Is there a way to get the list of non-unique records only?

 

[patriciaanne]

I haven't had a need for that but Pearson's site suggests several ways to identify duplicates depending upon what your needs are. Hope it helps.

http://www.cpearson.com/excel/duplicat.htm

 

[Dreamboat]

To keep only the items that appear in a filtered list, you can select all visible cells, hit Edit-Go to-Special-Visible cells only. Copy. Just an FYI, not sure if it works in your situation.

http://www.TheWordExpert.com

 

[loo]

Dim x

Sub deletion()
'
' Macro recorded 11/24/2001 by Leslie Opsahl


For x = 2 To 65000
If Cells(x, 2) = "" Then End
If Cells(x, 2) = Cells((x - 1), 2) Then Call remove
Next x
End Sub

Sub remove()


Rows(x - 1).Select
Selection.Delete Shift:=xlUp
x = x - 1
End Sub