Chip Pearson has documented many methods for dealing with duplicates and
uniques

See his page on this:

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


--
Regards,
Tom Ogilvy


"Tony" wrote in message
...
I need a macro that will delete duplicate data. I can
search on one column and delete the duplicate data. It is
possible that there is more than one duplication.
Ideally, I would like to keep the last entry, but I could
work around that if it was not possible. Any help would
be appreciated.

Tony