How to highlight duplicate values after certain condition is met

[mstjohn1974]

Hi there,

I have a spreadsheet with 20 columns and several hundreds of rows and I am looking in four columns where the first three are Firstname, Lastname and date and the fourth column contains a procedure code and my problem is that I have to find all customers (First, Lastname) that have duplicate procedure codes on the same day. The Firstname, Lastname and date can contain duplicates but not a duplicate procedure code on the same day. I am totally lost in how to solve this issue. Can I solve this issue with a macro?

Thanks for you help in advance

[dilipandey]

Hi mstjohn1974,

welcome to the forum.

since you have not uploaded any workbook, I have created a sample to help you.
used below formula to achieve the desired result:-

Please Login or Register  to view this content.

highlight dup values.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[FDibbins]

another option would be to create a helper column, combining code and date, and then using Conditional formatting - new rule/format only unique or duplicate values/duplicates. Format fill as required

[mstjohn1974]

Thanks dilipandey that worked great.....now I like to know is it also possible to additionally highlight those rows with the entry duplicate?

[FDibbins]

did you try post #3?

[dilipandey]

Hi John,

Used the same formula in conditional formatting and it seems to be working

highlight dup values.xlsx

Regards,
DILIPandey
<click on below * if this helps>