Check a box for duplicate rows, if also duplicate responses in another column

Gary_

Hi!

Hoping I can get some tips on a formula I am struggling with. I am trying to mark a check box based on if I have duplicates, based on two columns.

I am trying to identify duplicates between two rows by doing the following; (1) check entire sheet in one column for the same employee ID number (EID), and then for the rows with a duplicate EID check to see if the rows with the same EID also contain the same ID Color (ID Color).

Any suggestions would be helpful.

Paul Newcome

You would use an IF/COUNTIFS combo like so:

=IF(COUNTIFS(EID:EID, @cell = EID@row, [ID Color]:[ID Color], @cell = [ID Color]@row)> 1, 1)

Paul Newcome

You would use an IF/COUNTIFS combo like so:

=IF(COUNTIFS(EID:EID, @cell = EID@row, [ID Color]:[ID Color], @cell = [ID Color]@row)> 1, 1)

Cory Page

Can you share a screenshot of some sample sheet? Makes it easier to build a quick sheet on my end..

Hollie Green

If I am understanding correctly the below formula should work. You will need to replace with your actual column names. You will also need to make sure the row is a checkbox row type.

=IF(COUNTIFS([Employee ID]:[Employee ID], [Employee ID]@row, [Color ID]:[Color ID], [Color ID]@row) > 1, 1, 0)

Gary_

Thank you so much for the help, and so quickly! This helped me so very much.

Paul Newcome

Happy to help.️