I am using a checkbox to find duplicate entries in the column name Email. I can up with this that worked, =IF(COUNTIF(Email:Email, Email@row) > 1, 1).
Next, I am looking for both duplicates to not have a value in the Using Generic Account field and then check both boxes. Do not check either box if one of the two duplicates has a value in the Using Generic Account field. I can up with this =IFERROR(AND(IF(COUNTIF(Email:Email, Email@row) > 1, 1), IF(COUNTIF([Using Generic Account]:[Using Generic Account], [Using Generic Account]@row) > 1, 1)), 0).
This works if both rows do not have a value in the Using Generic Account field. But if one does, the one without the value is still checked.