IF duplicate AND a condition is met, then Check Box

mgsmith

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

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

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

Thank you! This worked!

Carson Penticuff

I'm glad it worked for you! 👍