How to remove duplicates?
 

In my column of 63000 entries their are some duplicates. Is their a simple
way of removing them? Thank you.

How to remove duplicates?
 

DataFilterAdvanced Filter.

Unique records only and copy to another location.

Delete original column.

You could copy the uniques to another worksheet if you start from that
worksheet.

See Debra's site for instructions.

http://www.contextures.on.ca/xladvfi...html#ExtractWs


Gord Dibben MS Excel MVP


On Fri, 25 Jan 2008 13:39:00 -0800, Lakewoodsale
wrote:

In my column of 63000 entries their are some duplicates. Is their a simple
way of removing them? Thank you.

How to remove duplicates?
 

If you're using Excel 2007...

Data tabData ToolsRemove duplicates

One of the more useful new features of Excel 2007!

--
Biff
Microsoft Excel MVP


"Lakewoodsale" wrote in message
...
In my column of 63000 entries their are some duplicates. Is their a
simple
way of removing them? Thank you.