Formula combining COUNT,DISTINCT & CONTAINS

Jayadeep K R

Screenshot 2023-08-05 at 11.46.28 AM.jpg

Hello SS Community,

Can you guide me on a formula to deal with the above data set?

In plain english, I need a Count of Distinct strings in the 'Release Set No." column Containing "Annual"

The answer in this case would be 8.

Is this possible on SS?

Thanks for your help!

Find more posts tagged with

Accepted answers

Paul Newcome

It would look like this:

=COUNT(DISTINCT(COLLECT([Release Set No.]:[Release Set No.], [Release Set No.]:[Release Set No.], CONTAINS("Annual", @cell))))

All comments

Paul Newcome

It would look like this:

=COUNT(DISTINCT(COLLECT([Release Set No.]:[Release Set No.], [Release Set No.]:[Release Set No.], CONTAINS("Annual", @cell))))

Jayadeep K R

YES, thank you Paul! Works

Using the 'Collect' formula was the missing link!

Paul Newcome

Happy to help. 👍️

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.