Chip has lots of stuff on duplicates at
www.cpearson.com
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"GRE" wrote in message
...
How can I delete redundant records in Excel without then leaving behind
what
will become a unique entry? I want all records that have a duplicate to
be
completely deleted from my list, no original from the duplicate left
behind.
Thanks!!