Duplicates

[lrsimon]

Last week several of you helped me in identifying duplicates in a list of 25,000+ names. Now that I have highlighted them in red for identification, how do I elimiate all other entries. I only need the duplicates and want to either draw them out or eliminate all other entries.

I've read about code modules, but haven't found anything telling me exactly how to enter them in VBE.

Thanks

[olasa]

Goto the menu: Select Data>Filter>Advanced Filter...
Use the tick box for 'Unique records only'
//Ola

[olasa]

Use a separate column: =COUNTIF($A$2:$A$25000,A2)>1
Use Autofilter, to filter out all that are False.
Then mark all visible rows and use Delete row
//Ola

[lrsimon]

Where do I "mark all visible rows" and "delete row"? Sorry, I'm sure this a dumb question.
Thanks

[olasa]

First take a copy of the file, just for safety.
Then move the cursor to the row numbers (the bar on the left side showing [1 to 65536] ) and click the bar so the whole row get selected and select all the rows that are visible and you would like to delete.

A fast way to select all rows - that I use - is to select the first row (click the bar so the whole row get selected) to delete, hold down the Shift button and then hit the End button once and the Arrow down button, then release the Shift button. Now all rows that you want to delete should be selected. This normally select all rows with a content.

Then goto menu: Edit>Delete rows
If you like you could also add a delete icon - if you like

Hope this helps
Ola