ttotus
asked on
Identify Duplicates in 2 Worksheets in Excel 2007
Hello Everyone,
I have two Excel sheets. One with a list of existing customers, and one with a list of potential customers or "leads". These two sheets have different columns than one another, but the phone number column on both are formatted the same. I would like to check the potential customer worksheet against the existing customer worksheet to identify duplicates using the phone number columns in each. In other words, I want to make sure none of these potential customers are already customers of ours.
I have tried identifying duplicates using a new column on the potential customer sheet with no luck based on something I found online but I'm not sure if this would even work? =ISNUMBER(MATCH(G2,'Existi ng Customers'!G2:G2111,0))
I have two Excel sheets. One with a list of existing customers, and one with a list of potential customers or "leads". These two sheets have different columns than one another, but the phone number column on both are formatted the same. I would like to check the potential customer worksheet against the existing customer worksheet to identify duplicates using the phone number columns in each. In other words, I want to make sure none of these potential customers are already customers of ours.
I have tried identifying duplicates using a new column on the potential customer sheet with no luck based on something I found online but I'm not sure if this would even work? =ISNUMBER(MATCH(G2,'Existi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check first if you have formula calculations set to manual.
in the Formulas tab|Calculation Options drop down.. should be Automatic.... can you verify?
in the Formulas tab|Calculation Options drop down.. should be Automatic.... can you verify?
ASKER
It ended up working. The numbers were "stored as text" so I converted them to being stored as numbers and the formula started working. Thank you!
ASKER
When I use that formula on an open column on the Potential customer worksheet I get true all the way down the column. I have confirmed that many are not duplicates that are appearing as true.
Some more information:
Worksheet "Existing Customers" contains phone numbers in the G2:G2422 range, all formatted the same way "0000000000".
Worksheet "Potential Customers" contains phone numbers in the G2:G312 range, all formatted the same way "0000000000".
I have added a blank column to use for checking duplicates (for the formula you gave me) on the "Potential Customers" worksheet and added the formula you supplied and I receive true for all formula results. Hopefully it's something I'm just doing incorrectly. Thank you for your time!