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.
|