--Select the Column with data including the header. You need to have header
for this column..Say Col A
--From menu DataFilterAdvanced FilterCopy to another location
--In 'copy to' selected another cell say G1 and check 'Unique records only'
--Click OK will give you the unique list in Col G

--
Jacob (MVP - Excel)


"Bill" wrote:

i have a large database with many of the email address' doubled or tripled,
how can i easily filter all the doubles out?