I have two lists, one with 400 names and one with 4000 names. I want to find
out how many of the 400names are on the list of 4000. Please help.

See replies to your multiple posts.

Biff

"Ed" wrote in message
...
I have two lists, one with 400 names and one with 4000 names. I want to
find
out how many of the 400names are on the list of 4000. Please help.

Enter this formula in column B.

=SUM(IF(A1=$C$1:$C$4000,1)) enter this formula and than press
Ctrl+Shift+Enter together.

In column A should be 400 name list.
In column C - 4000 name list.
Copy down this formula for all 400 names in column A.