Column A has last names. column B has first names. There are some names that are duplicate. I have about 2500 rows. How to get highlighted the duplicate full name. Please help.
Column A has last names. column B has first names. There are some names that are duplicate. I have about 2500 rows. How to get highlighted the duplicate full name. Please help.
Column c =A1&B1
Column d =countif(C:C,c1)
Duplicates will show more than 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks