In vs2007 it's a snap!

Simply highlight the data, and in the Data tab, you'll see a Remove
Duplicates option. Just follow the procedure.

Rob

"bratka" wrote in message
...
Can not find out how to find duplicate records in large excel file and
delete
duplicates by leaving just one unique record of each. Please help.