How can I cross reference 2 excel docs to look for duplicate info
Hi,
You may try the following array formula:
If list A is is in range A1:A10 and list B is in range B1:B10
In cell C1, array enter the following formula (Ctrl+Shift+Enter)
=or(exact(A1,B1:B10))
This will return true for any matches found.
Regards,
Ashish Mathur
"DutchBella" wrote:
I have two different company lists of customers in separate Excel
spreadsheets that I need to cross reference with each other to see if the
companies have any of the same customers.
|