[thelist] OT -deleting dupLicates in excel document

Dan CRACIUN dcsquare at myrealbox.com
Fri May 6 04:12:42 CDT 2005

Late, I think, but the solution is simple:
Use Data->Filter->Advanced Filter and check "Unique records only"

Best regards,

Bruce Gilbert wrote:

>this may be a bit off topic, but I'm in a bind.
>I have an excel document full of company email addresses, that I need
>to send a mass emailing out to. Problem is the filtering of the
>database gave me a document with MULTIPLE email addresses for many
>people. Is there a relatively quick way to get rid of the duplicates
>in excel without doing in manually? We're talking about 6,000 names
>thanks in advance!

More information about the thelist mailing list