Flag the records using Countif, then filter on the duplicates and delete.

Turn on the macro recorder while you do it manually to get the code.

--
Regards,
Tom Ogilvy

"Charles Deng" wrote in message
...
I have a huge data set on Excel. I would like to know
what programming codes (Macro)I can use to delete those
duplicate records on a specific column, such as column F.
Any help will be highly appreciated.


Charles Deng