[thelist] OT -deleting dupLicates in excel document

Bruce Gilbert webguync at gmail.com
Thu May 5 13:49:00 CDT 2005


thanks for all the reponses. FWIW, this is the way I chose to get rid
of the duplicates, b/c it seemed like it would be the easiest(and it
was). I like to avoid excel formulas as much as I can!

thanks again,

On 5/5/05, Getafixx <getafixx at getafixx.com> wrote:
> I think people are gong about this the wrong way.
> 
> download editplus [1]
> 
> copy lilst of email addresses (or just copy the column)
> 
> paste into editplus
> 
> choose tools-> sort, and select your options, making sure you tick
> remove duplicates
> 
> [1] http://www.editplus.com
> 
> I hope this helps.
> 
> Justin
> 
> 
> Brian Cummiskey wrote:
> > Bruce Gilbert wrote:
> >
> >> Hello,
> >>
> >> 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
> >> here.
> >>
> >> thanks in advance!
> >
> >
> > do you have access to a sql database?
> >
> > if so, just import it into a temp DB table.
> > then, run
> > select distinct email_address from tablename
> >
> > copy paste that list.
> >
> > shouldn't take more than 2 min :)
> >
> 
> --
> ==============================================================
> Justin / Getafixx                                07967 638 529
> mailto:qwerty1 at getafixx.com
> 
> http://getafixx.com
> http://getafixxhosting.com for really cheap web hosting
> ==============================================================
> 
> 


-- 
::Bruce::


More information about the thelist mailing list