Finding duplicate entries?

[Kenny]

I have a
very large, 25,000 rows x 6 columns, spreadsheet. It's updated occasionally
using Copy & Paste. I believe I have added the same updates more than once.
Is there some way in Excel I can search for identical/duplicated
entries so that I can remove them?
Someone suggested converting it to an Access database and it can be searched
for duplicates there but I don't know how? Using Office XP and a bit of a
novice with it apart from Word..

 

[J.E. McGimpsey]

Take a look at

http://cpearson.com/excel/duplicat.htm

 

[Kenny]

Thanks for the reply, have saved that page to study it.