Create a new unique list in another column with DataFilterAdvanced
Filter... It has a unique records option.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mags" wrote in message
...
I have a very large mailing list in an excel format with duplicates and
triplicates that I would like to dedupe.