common entries between 2 columns
 

I have two lists of numbers or names and I want to find the ones that are
common between the 2. The lists are say column A and column B in excel.

Andreas,

In cell C1, use the formula

=IF(ISERROR(MATCH(B1,A:A,FALSE)),"","Also in column A")

And copy down to match your list in column B.

You can write a similar formula to highlight the values in column A.

HTH,
Bernie
MS Excel MVP


"Andreas" wrote in message
...
I have two lists of numbers or names and I want to find the ones that are
common between the 2. The lists are say column A and column B in excel.

Hi,

Try this. Assuming you have one list in range A1:A5 and the other one in
range B1:B5, enter hter following array formula (Strl+Shift+Enter) in cell C1

=OR(EXACT(A1,$B$1:B5))

Regards,

"Andreas" wrote:

I have two lists of numbers or names and I want to find the ones that are
common between the 2. The lists are say column A and column B in excel.