removing duplicates and deleting the row

[zibanitum]

I have a large excel spreadsheet that has several columns and over 14000 rows. I have one column that displays and ID number. Some of these ID numbers are duplicates. I would like to find a macro/formula or whatever to delete the rows the duplicates occur on. I only want unique id numbers.

How can I do this? Any help would be appreciated. Thank you.

 

[joy_666]

Hey,

Have you tried using Tom's VB code given above???

 

[joy_666]

Hey Steven,

Your other thread was resolved by VOG.

http://www.mrexcel.com/forum/showthread.php?t=378993