Data Cleansing - Reversed names

Hi Angie and welcome

You could use text to columns to split the name into two columns and then use COUNTIFS to check.

I'll put together a little example and post it in a moment.

EDIT: Now attached. It's quick and dirty and not quite as sophisticated as the fuzzy matching that Sam mentions, but it might be enough to do what you need.

BSB

have you looked into the fuzzy lookup addin by Microsoft? https://www.microsoft.com/en-us/down....aspx?id=15011
it's description:
It can be used to identify fuzzy duplicate rows within a single table or to fuzzy join similar rows between two different tables. The matching is robust to a wide variety of errors including spelling mistakes, abbreviations, synonyms and added/missing data. For instance, it might detect that the rows “Mr. Andrew Hill”, “Hill, Andrew R.” and “Andy Hill” all refer to the same underlying entity, returning a similarity score along with each match.