Return most occurring value in multi-select column
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?
Help Article Resources
Check out the Formula Handbook template!