Being an avid user of Excel, I have tried various ways to search for
duplicate records in an Excel spreadsheet that might contain over 2,000
entries. The issue is different people entering data in different ways.
Examples a Chuck Jones vs Charles Jones, Robert Andrews vs Bob Andrews vs
Bobby Andrews, Matt Black vs Matthew Black, etc. Since the first and last
name are in the same cell I cannot simply search by last name. In some
cases, there are even more than 2 entries for the same person. Is there a
way to search for these near duplicates that don't match exactly?

Hi Carol,

This may not be what you're looking for , but if all the names are in the
same column you could use a filter that contains "Jones" etc.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


"Carol" wrote:

Being an avid user of Excel, I have tried various ways to search for
duplicate records in an Excel spreadsheet that might contain over 2,000
entries. The issue is different people entering data in different ways.
Examples a Chuck Jones vs Charles Jones, Robert Andrews vs Bob Andrews vs
Bobby Andrews, Matt Black vs Matthew Black, etc. Since the first and last
name are in the same cell I cannot simply search by last name. In some
cases, there are even more than 2 entries for the same person. Is there a
way to search for these near duplicates that don't match exactly?