Delete Duplicates in Excel

[wxue]

I have 10,000 numbers, from Excel A1 to A10000. I need to find the duplicates and delete. What is the most effient way?

I made a vba, it take one min to work it out. Too slow... Thanks

 

[Greg Truby]

Do a search here for "delete duplicate rows" and you'll find over a hundred threads on this subject.

 

[hkaplan2]

One simple way is to create a pivot table with the numbers field in the rows section of the PT wizard and the numbers field in the data section, set to display the count of each number (it will default to sum so you need to change to count). Then copy the numbers column from the resulting pivot table. It will only show unique numbers.

 

[wxue]

Thanks