Return most occurring value in multi-select column

C. Powell

Hello,

I'm trying to count the most occurring value (text not number) in a multi-select column, then return that value. Is there a way to count distinct values, rank then return the value with the highest rank in one formula without setting up a separate helper column or metric sheet?

Thank you!

Paul Newcome

There is not. You will need some kind of helper column or separate sheet to accomplish this.

Paul Newcome

There is not. You will need some kind of helper column or separate sheet to accomplish this.

Leibel S

@C. Powell

AS @Paul Newcome says you will need some sort of helper. any specific reason you dont want a metric sheet?

If there is only a few, you should be ale to do it within the sheet summary, it just might get complicated...

C. Powell

Thank you, both! My motivation is only to reduce additional columns, sheets and sheet summary fields, if possible. I will proceed with helpers!