find names on list 1 in list 2. list 1 4000 names list 2 400 name

I need help comparing 2 lists in excel. Here is my goal; I have one list with
4500 names and one list with 400 names. I would like to find out which of the
400 names is on the 4500 name list. how do I do it? thanks for your help.

You can use the technique described here

http://www.cpearson.com/excel/duplicat.htm

--
Regards,

Peo Sjoblom

(No private emails please)


"Ed" <Ed@discussions.microsoft.com> wrote in message
news:84AE539C-B3B3-4FE1-8702-53314977098E@microsoft.com...
>I need help comparing 2 lists in excel. Here is my goal; I have one list
>with
> 4500 names and one list with 400 names. I would like to find out which of
> the
> 400 names is on the 4500 name list. how do I do it? thanks for your help.

You can use the technique described here

http://www.cpearson.com/excel/duplicat.htm

--
Regards,

Peo Sjoblom

(No private emails please)


"Ed" <Ed@discussions.microsoft.com> wrote in message
news:84AE539C-B3B3-4FE1-8702-53314977098E@microsoft.com...
>I need help comparing 2 lists in excel. Here is my goal; I have one list
>with
> 4500 names and one list with 400 names. I would like to find out which of
> the
> 400 names is on the 4500 name list. how do I do it? thanks for your help.

You can use the technique described here

http://www.cpearson.com/excel/duplicat.htm

--
Regards,

Peo Sjoblom

(No private emails please)


"Ed" <Ed@discussions.microsoft.com> wrote in message
news:84AE539C-B3B3-4FE1-8702-53314977098E@microsoft.com...
>I need help comparing 2 lists in excel. Here is my goal; I have one list
>with
> 4500 names and one list with 400 names. I would like to find out which of
> the
> 400 names is on the 4500 name list. how do I do it? thanks for your help.