You could use data|filter|advanced filter (unique records only) and put the list
in a different location.

Then delete the original and keep the filtered list. Make sure you have a
header in your list.

Debra Dalgleish's instructions:
http://www.contextures.com/xladvfilter01.html#FilterUR

And Chip Pearson has some techniques at:
http://www.cpearson.com/excel/duplicat.htm


Greg wrote:

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?




--

Dave Peterson