Help please!

[Simon L]

I have a sheet with 2 columns of email addresses set up in it. There is
some overlap in the information held in the 2 columns (I.e. some email
addresses appear in both columns), is there anyway I can get rid the
overlap so the email address only appears once?

Thanks,
Simon

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon
http://www.cpearson.com/excel/duplicat.htm#ExtractingUnique

Frank

 

[Full Monty]

Simon,
Use the CountIF function in the third column. Then use the autofilte
to show all the ones with numbers in the third column.

Just delete the ones shown. That's the simplest way

 

[guilbj2]

Is the list large ? How many cells are we talking about here

 

[Simon L]

*Is the list large ? How many cells are we talking about here ? *

There are 611 addies in column A and 682 addies in column B

 

[guilbj2]

If that's the case, you should try the solutions found here...

http://www.cpearson.com/excel/dupli...xtractingCommon
http://www.cpearson.com/excel/dupli...xtractingUnique

There are formulas here that will do the sorting for you

 

[Simon L]

Thanks for your help guys.....