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
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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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!