Link to home
Start Free TrialLog in
Avatar of ttotus
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,'Existing Customers'!G2:G2111,0))
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ttotus
ttotus

ASKER

Hi NB_VC,

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!
Check first if you have formula calculations set to manual.

in the Formulas tab|Calculation Options drop down.. should be Automatic....  can you verify?
Avatar of ttotus

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!