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?