Formula combining COUNT,DISTINCT & CONTAINS

Jayadeep K R

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!

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))))

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. 👍️