I am trying to find all the duplicate values that exist in a column i created using a concatenate formula in Excel.
I was working with 2 columns of data, one containing client last names and the other containing dates of birth. Some of the names are duplicates for the same person (same last name and DOB that appears each time the person placed an order). However, some of the last names apply to totally separate individuals (same last name different DOB).
I used a concatenate formula combining the two columns and now have a list of all the individual names that appear in my original list without the duplicates. Excel also created a unique identifier to go with each last name. My problem is that the person who originally entered the data made spelling errors with some of the names (ex. smith 351339 and smyth 351339). Each entry corresponds to the same person, but it is listed in 2 separate rows in my new sheet. Is there a formula that can identify the mistake duplicates by searching for the partial last name and unique identifier?