Finding and highlight duplicate names

Queeva

New Member
Joined
Jul 27, 2007
Messages
2
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!
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

brian.wethington

Well-known Member
Joined
Jul 20, 2006
Messages
1,739
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)
Code:
=countif($A$2:$F$100, A2) > 1
Click the format button and format as desired.
Click OK, and OK

Hope this helps!
 

Queeva

New Member
Joined
Jul 27, 2007
Messages
2
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

Well-known Member
Joined
Jul 20, 2006
Messages
1,739
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):

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

Forum statistics

Threads
1,181,607
Messages
5,930,874
Members
436,764
Latest member
avalladarez

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top