Count(Distinct(Collect Formula

Smar Czar

I am trying to write a formula to return a count of the number of unique IDs market propject and then counted by market. From what I have been reading it seems like a count(distinct(collect formula is needed. Also, I might need a helper column on my source sheet to determine which rows are unique.

SSFeatures

Hi @Smar Czar, just so that I understand better, you want to count the number of unique combinations of (ID, Project, Market)?

You can create a helper column named "Key" with the following formula:

=ID@row + "-" + Project@row + "-" + Market@row

This helper column will act as a key that we can use to compare with other keys, to count the number of unique ones.

Then this formula will collect the number of distinct ones:

=COUNT(DISTINCT(Key:Key))

I hope this helps!

SSFeatures

Hi @Smar Czar, just so that I understand better, you want to count the number of unique combinations of (ID, Project, Market)?

You can create a helper column named "Key" with the following formula:

=ID@row + "-" + Project@row + "-" + Market@row

This helper column will act as a key that we can use to compare with other keys, to count the number of unique ones.

Then this formula will collect the number of distinct ones:

=COUNT(DISTINCT(Key:Key))

I hope this helps!

Smar Czar

Thank you @SSFeatures ! It worked. Appreciate your help as always.

SSFeatures

@Smar Czar You're welcome! Glad it worked!