Solved Excel Conditional Format duplicate rows with mismatched reco

August 9, 2019 at 18:18:42
Specs: Windows 10
Excel Conditional Format duplicate rows with mismatched record:
I have employee records where an employee can have more than one row based on his rate, I want to format the rows where the employee Id is not unique to the employee
if the id is duplicated but his last name and first name are not the same as the duplicate ID to highlight the mismatched records.example Shows a mismatched rows in row 2 and row 8,also mismatch records in row 5 and 6. Thanks for the help in advance.
Row # Employee ID Last name First Name Rate
2 10 Smith Mike 10
3 20 Davis Kim 20
4 20 Davis Kim 10
5 40 Smith Kim 10
6 40 Kim Smith 15
7 50 Jones Tom 10
8 10 Smith John 10
9 30 Smith John 10
10 60 Jones Lisa 10


See More: Excel Conditional Format duplicate rows with mismatched reco

Reply ↓  Report •

#1
August 9, 2019 at 20:20:34
First, a posting tip:

Please click on the How-To link at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

Thanks!

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
August 14, 2019 at 12:22:53
✔ Best Answer
I got the answer from another site, the formula for the conditional format is
=COUNTIFS($A:$A,$A2,$B:$B,$B2,$C:$C,$C2)<>COUNTIF($A:$A,$A2)

message edited by VetJunkie


Reply ↓  Report •

#3
August 14, 2019 at 15:19:20

Glad you found a solution and thanks for coming back and sharing it.

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question