IF duplicate AND a condition is met, then Check Box

mgsmith · 02/14/25

I need to create a formula that will check a box if there is a duplicate in one column and in the same row a condition is met.

The duplicate would patient MRN and the condition in would be "Referred".

If the MRN is a duplicate and only if "Referred" is selected for both rows would the checkbox be checked on both rows.

If the MRN is a duplicate, but one row is "Referred" and the other row is "Not Referred" then no checkbox.

Thank you for the help!!

Carson Penticuff · 02/15/25

You will need to adjust the column names to match your sheet, but other than that, this should get you where you need to go:

=IF(COUNTIFS([Patient MRN]:[Patient MRN], [Patient MRN]@row, [Referred Column]:[Referred Column], "Referred") > 1, 1, 0)

Carson Penticuff · 02/15/25

You will need to adjust the column names to match your sheet, but other than that, this should get you where you need to go:

=IF(COUNTIFS([Patient MRN]:[Patient MRN], [Patient MRN]@row, [Referred Column]:[Referred Column], "Referred") > 1, 1, 0)

mgsmith · 02/15/25

Thank you! This worked!

Carson Penticuff · 02/17/25

I'm glad it worked for you! 👍

Formulas and Functions