How do you suppress duplicate lines?

[LindaCC]

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?

 

[Bernard Liengme]

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

 

[mattyboy150279]

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

 

[LindaCC]

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.

 

[LindaCC]

Thank you. That site helped a lot!

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