Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I cross reference 2 excel docs to look for duplicate info
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 - automating getting info from web | Excel Discussion (Misc queries) | |||
Excel validation drop-down: how show codes with descriptive info? | Excel Discussion (Misc queries) | |||
I found reference to info that I need on Excel-how do I acess the | Charts and Charting in Excel | |||
How Do I Get a date reference when linking excel worksheets? | Excel Worksheet Functions | |||
getting specific info from a word document into excel | Excel Discussion (Misc queries) |