Finding and highlight duplicate names

[Queeva]

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!

 

[brian.wethington]

Welcome to the board!

There are actually many ways to do this....

The first way that comes to mind would be conditional formatting.....

Select the data starting from the top left to the bottom right.
Choose the format menu
Conditional Formatting
Change Cell Value to Formula is
Enter in the field (assuming your data starts in A2 and ends in F100, adjust as needed)

=countif($A$2:$F$100, A2) > 1

Click the format button and format as desired.
Click OK, and OK

Hope this helps!

 

[Queeva]

Thank you thank you.

Can this be done across two worksheets? Comparing data in one to the other?

All the data is names.

 

[brian.wethington]

Are the 2 shieets in the same workbook. If so it may look something like this for your formula (This is what it would look like in Sheet1 to check sheet1 and sheet2):

=(Countif(Sheet1!$A$2:$A$100, Sheet1!A2) + Countif(Sheet2!$A$2:$A$100, Sheet1!A2)) > 1