Identify duplicates in a column excluding blanks and a second criteria

bketch

I am trying to identify duplicates excluding blanks and another criteria in the same column.

Exp. The column has phone numbers, blanks, and a word like Not Available

This is as far as I have gotten but cannot find a way to exclude the "Not Available" or make it 0 as well.

I have identified dupes and blanks so far...

=IF([Phone]@row = "", 0, “COVP”, 0,IF(COUNTIFS([Phone]:[Phone], [Phone]@row) = 1, 0, 1))

I appreciate any help!

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @bketch

If I understand your request, you only want the formula to run when the row contains a number, and not when the row contains words or blanks? If I understood correctly, then try this.

=IFERROR(IF(ISNUMBER(VALUE(LEFT(Phone@row, 3))), 1), 0)

Will this work for you?

Kelly

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.