Distinct Function and creating a helper column

Well, I am striking out. I want to create a helper column generated off the Distinct Formula. Basically, i want to place a 1 in a column if the [Base] Column is distinct to other entries.

=IF(DISTINCT(Base:Base), 1, 0) is my formula thought but i dont know exactly how to accomplish this.

Thanks for your help in advance!

Find more posts tagged with

Accepted answers

All comments

Christian Graf

Try this:

=IF(COUNTIFS(Base:Base, Base@row) = 1, 1, 0)

Hope it helps.

Jeremy Norman

@Christian Graf Thanks for your help. Unfortunately, the formula only places Zeros in the column. It does not count any of the distinct bases.

Any other thoughts?

Christian Graf

@Jeremy Norman

Did you convert it to a column formula? It should work.

If you are only getting zeros, then those bases are not distinct values. They must have duplicates.

What value format are these "bases" are these numeric values, or character values?

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.