Hi,
Look into CPearson web, scroll down a little to where it says Extracting
elements common to two list

http://www.cpearson.com/excel/ListFunctions.aspx

hope this helps

"Ana" wrote:

Hello,

I have a question for you; could you please help?
I have column A with 300 names and column B with 7000 names.

I would like to list the names in column A that are also in column B.

Is there a function/macro that could do that?
Thanks,
Ana