Value of highest count

[Anonymous]

Hi all,

I want to get the value which belongs to the highest count. So:

Name:     Count:

Paul      1

David     1

David     1

Harry     1

David     1

So, now I want an expression which gives David as a output as he has the highest count.

Thank you!

[sergio0592 · Accepted solution]

Hi, try with :

=FirstSortedValue(Name,-aggr(sum(Count),Name))

[Anonymous]

That worked, thanks!

[Monicalingan]

Hi Joost,

Few more ways

=if(Right(Text(Name&'/'&Rank(Count(Name))),2)='/1',Name,'')

or

=if(Right(Text(Name&'/'&Rank(Sum(Count))),2)='/1',Name,'')