ExcelBanter - View Single Post - Need help finding non-duplicate email addresses...

It might be easier to show you what I have:

Nam

Richard
Robert

I want to eliminate the duplicate addresses:

and save the non-duplicate addresses.

"Paul Lautman" wrote:

Greg wrote:
Hi Paul,

Thanks for your reply. No the lists are vertical but can be horizonal
if that helps. And it is currently one list but I can make them into
two list as well.

-Greg

"Paul Lautman" wrote:

Are you saying that you have 2 lists and you wish to find what items
from one list do not exist in the other one?

If so are both these lists horizontal?

If the lists are vertical, what is the "row of e-mail addresses" of which
you speak?