Duplicate (countif) keeps showing false value

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.

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.