How to find dublicates in Excel and delete it?

[bratka]

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.

 

[RobN]

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

 

[Joan]

What if a person is using v2003?

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

 

[RobN]

Sorry....I've only got 2007 now. A 2003 user will need to hop in here.

Or, maybe look for removing duplicates in your version's Help.

Rob

 

[bratka]

Thanks Rob and Joan!

I'm using Excel 2003 and with your help located a software called Duplicates
Remover at http://www.ablebits.com/excel-remove-duplicates/index.php and
removed all duplicates using it

Thanks again!

Bratka G

 

[Franz Erhart]

This should help, though I didn't try it myself.
And it's free of charge.

http://support.microsoft.com/kb/262277/EN-US/

 

[Dave Peterson]

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx