How do you suppress duplicate lines?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LindaCC - 25 Aug 2006 16:35 GMT

I am combining mailing lists from different sources and I need to delete any
duplicate entries, is there an easy way to do this in excel?

Reply to this Message

Bernard Liengme - 25 Aug 2006 17:15 GMT

Visit Chip's site http://www.cpearson.com/excel/duplicat.htm
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I am combining mailing lists from different sources and I need to delete
>any
> duplicate entries, is there an easy way to do this in excel?

Reply to this Message

LindaCC - 25 Aug 2006 19:12 GMT

Thank you! Between Chip's site and another one, I came up with a solution
that will more than help our Development Dept. in de-duping their mailing
lists.

> Visit Chip's site http://www.cpearson.com/excel/duplicat.htm
> best wishes
> >I am combining mailing lists from different sources and I need to delete
> >any
> > duplicate entries, is there an easy way to do this in excel?

Reply to this Message

mattyboy150279@gmail.com - 25 Aug 2006 17:16 GMT

Try this link, which explains various ways of dealing with duplicate
entries in an Excel worksheet:-

http://www.cpearson.com/excel/duplicat.htm

Hope this helps,
Matt

> I am combining mailing lists from different sources and I need to delete any
> duplicate entries, is there an easy way to do this in excel?

Reply to this Message

LindaCC - 25 Aug 2006 19:13 GMT

Thank you. That site helped a lot! :)

> Try this link, which explains various ways of dealing with duplicate
> entries in an Excel worksheet:-
[quoted text clipped - 6 lines]
> > I am combining mailing lists from different sources and I need to delete any
> > duplicate entries, is there an easy way to do this in excel?

Reply to this Message