Hi there,
I have two spreadsheets, thousands of names generating from another software program.
I can combine the lists on one worksheet, but I need a way to find duplicate names on the list and highlight them for review.
Has anyone encountered anything like this before?
I am reading "Locate Duplicates" on the MS site, but it seems to only show how to do it with numbers and on a very small scale.
Thanks!
I have two spreadsheets, thousands of names generating from another software program.
I can combine the lists on one worksheet, but I need a way to find duplicate names on the list and highlight them for review.
Has anyone encountered anything like this before?
I am reading "Locate Duplicates" on the MS site, but it seems to only show how to do it with numbers and on a very small scale.
Thanks!