Duplicate (countif) keeps showing false value

aaaccclll

I am using the countif function to show if a duplicate exists, but it keeps counting when there is no duplicate.

=COUNTIF(EID:EID, EID@row)

It works for the previous data I created, but when I add more using the forms, it always shows 1 as a duplicate count for the column. Even when I type in random letters and numbers, it will always show as 1. It only shows as 0 when I change the value to more than one zero.

Linda Manduchova

Hello @aaaccclll -

Try the following formula:

=IF (COUNTIF (EID:EID, EID@row) > 1, 1, 0)

Hope this helps!

Linda

aaaccclll

Thank you for the quick response @Linda Manduchova

I am not sure that it worked. Now it will not count any duplicates 😂

Linda Manduchova

@aaaccclll - this was meant to be for a checkbox (whether is a flag, star, or checkbox) column. If a duplicate is identified then the checkbox gets checked, otherwise; the checkbox is unchecked.

Linda