Find duplicate in row based on cell value.

[bicSkylighter]

I'm looking to highlight/identify duplicates in a row based on a common title (same) and am not sure of the direction to proceed.

Simple example:

There are two helpdesk title's and both are part of similar groups. I would like to identify all groups that "helpdesk" have in common. Then continue with each same title to find to find duplicates.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Title[/TD]
[TD="align: center"]Group1[/TD]
[TD="align: center"]Group2[/TD]
[TD="align: center"]Group3[/TD]
[TD="align: center"]Group4[/TD]
[TD="align: center"]Group5[/TD]
[TD="align: center"]Group6[/TD]
[/TR]
[TR]
[TD]Helpdesk[/TD]
[TD]Help[/TD]
[TD]Support[/TD]
[TD]email[/TD]
[TD]test[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Helpdesk[/TD]
[TD]Help[/TD]
[TD]Support[/TD]
[TD]email[/TD]
[TD]website[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Desktop[/TD]
[TD]Help[/TD]
[TD]Desktop[/TD]
[TD]support[/TD]
[TD]website[/TD]
[TD]server[/TD]
[TD]test[/TD]
[/TR]
[TR]
[TD]Manager[/TD]
[TD]Desktop[/TD]
[TD]support[/TD]
[TD]website[/TD]
[TD]server[/TD]
[TD]manager[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Manager[/TD]
[TD]Help[/TD]
[TD]support[/TD]
[TD]email[/TD]
[TD]manager[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I would be doing this for around 150 "title's" and couple hundred of groups.

 

[Eric W]

Welcome to the MrExcel forum!

Assuming your range starts in cell A1 (the word "Title"), try this:

Select columns B:G. Click Conditional Formatting > New Rule > Use a formula > and enter:

=AND(SUMPRODUCT(($B$1:$G$10=B1)*($A$1:$A$10=$A1))>1,B1<>"")

Click Format... and choose a fill color. You'll need to change the ranges to match your sheet. I used columns B:G and rows 1:10, but change those to fit the range you're using.

 

[bicSkylighter]

Thanks for the welcome Eric and thank you more for nailing the answer so quickly. Your solution worked perfectly.

Thank you!

 

[Eric W]

Happy to help!