Check for duplicates and exclude blank cells

Hi. I am trying to write a formula that will check for duplicates in a column but skip the blanks. The normal formula I use is Countif([Column Name]:[Column Name], [Column Name]@row) this counts blanks. I have tried =IF(ISBLANK([Column Name]@row), 0, IF(COUNTIF([Column Name]:[Column Name], [AColumn Name]@row) > 1, 1)) I get an incorrect argument error. I have also tried =IF([Column Name]@row ISBLANK(), "0", COUNTIF([Column Name]:[Column Name], [Column Name]@row)) but I get an unparsable error.

Find more posts tagged with

Formulas

Accepted answers

Christina09

Hi @Christopher Pretty

You can try to use "" instead of ISBLANK. It pretty much means the same thing.

=IF([Column Name]@row = "", 0, IF(COUNTIFS([Column Name]:[Column Name], [Column Name]@row) = 1, 0, 1))

Hope this works for you.

All comments

Christina09

Hi @Christopher Pretty

You can try to use "" instead of ISBLANK. It pretty much means the same thing.

=IF([Column Name]@row = "", 0, IF(COUNTIFS([Column Name]:[Column Name], [Column Name]@row) = 1, 0, 1))

Hope this works for you.

Christopher Pretty

Thank you. That worked!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.