Check out what Chip Pearson has to say here...
http://www.cpearson.com/excel/duplicat.htm
I don't believe there is an answer there that exactly meets your needs
but there are some good techniques that you can possibly modify.

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins)



"Roger Bell"
wrote in message
I have a spreadsheet with 3 columns; Name, Company & email address. I have
discovered that some of these rows (records) have been duplicated. Is there
a way I can remove just the rows of data where all the information in the 3
columns has been duplicated?

Thanks for any help