[thelist] OT -deleting dupLicates in excel document

Shawn K. Quinn skquinn at speakeasy.net
Thu May 5 14:21:08 CDT 2005


On Thu, 2005-05-05 at 11:57 -0400, Bruce Gilbert wrote:
> 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
> here.

(Posted in hope this is useful for someone down the road)

With the addresses in a text file, this is pretty simple on Unix-like
systems: 

cat original.list | sort | uniq > new.list

-- 
Shawn K. Quinn <skquinn at speakeasy.net>



More information about the thelist mailing list