Hi,

I have a list of email addresses which I would like to find only the
new email addresses within the list. Inside of my Excel worksheet I
have a row of e-mail addresses. Some of the names are duplicated which
tells me they already exist somewhere in the row. I wish to display
only the new names. Can you tell me how this can be done in Excel?

Thanks in advance for your assistance,
Greg

Greg wrote:
Hi,

I have a list of email addresses which I would like to find only the
new email addresses within the list. Inside of my Excel worksheet I
have a row of e-mail addresses. Some of the names are duplicated which
tells me they already exist somewhere in the row. I wish to display
only the new names. Can you tell me how this can be done in Excel?

Thanks in advance for your assistance,
Greg

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?

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?

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?

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?

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

Hi,

Answer found:

I posted my question to another Excel newsgroup and received the following
reply which I was able to replicate and does resolve my problem:

Source email list is in A1 down

In B1: =IF(A1="","",IF(COUNTIF(A:A,A1)=2,"",ROW()))

In C1: =IF(ISERROR(SMALL(B:B,ROW())),"",
INDEX(A:A,MATCH(SMALL(B:B,ROW()),B:B,0)))

Select B1:C1, copy down to last email in col A

Col C returns the required list, viz.:

Note: The above solution requires that all preceding and trailing angle
brackets "<" be removed from the e-mail address.

You can also use the following weblinks to see the answer:

http://groups.google.com/group/micro...1a3dfe9a785d49

http://groups.google.com/group/micro...b80d8a2e127197

I wish to thank everyone who took time to respond and provided alternative
suggestions. Your support is greatly appreciated.

-Greg

"Greg" wrote:

Hi,

I have a list of email addresses which I would like to find only the
new email addresses within the list. Inside of my Excel worksheet I
have a row of e-mail addresses. Some of the names are duplicated which
tells me they already exist somewhere in the row. I wish to display
only the new names. Can you tell me how this can be done in Excel?

Thanks in advance for your assistance,
Greg

good sir

i need emails addresses

url:http://www.ureader.com/msg/103431849.aspx