1

I have a spreadsheet of patient data (several thousand records) where I need a way to indicate whether there's a duplicate patient. We know there's a duplicate if the last name and the date of birth are the same, which are in two separate columns. Does anyone know how to use conditional formatting to highlight either the row or those cells when there's a duplicate in two columns? This is a sample of what the data look like (fake data):

3

1 Answer 1

0

I believe the following forula will work for you:

=AND(C1<>"",COUNTIF(ARRAYFORMULA($C:$C&$E:$E),index(ARRAYFORMULA($C:$C&$E:$E),ROW($C1),))>1)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.