Look at DataFilterAdvanced filter, it has a unique option.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Julie Melbourne" <Julie wrote in
message ...
How do I deduplicate data in Excel. I have a large database of names and
addresses which I want to check to duplication