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