Get Max average form a data set

[anuradhaa]

Hi,

I have a data set like below,

                          SUBJECT 1     SUBJECT 2     SUBJECT 3

STUDENT A          58                         96                    75

STUDENT B          36                         89                    72

STUDENT C          44                         60                    90

I want to get the STUDENT who has the highest AVERAGE in all subjects,

Pls help me.

Thanks

[Anonymous]

max(aggr(avg(Score),Student))

[tresesco · Accepted solution]

May be like this?

=FirstSortedvalue( Student, -Aggr(Avg(Score), Student))

[MK_QSL]

Check enclosed file...

[#5]

try this

if(max((subject1+subject2+subject3)/3)<>0,Student)

[anuradhaa]

Thanks All

[anuradhaa]

How to get the lowset one, i try with lastsortedvalue but doesn't work.

thanks

[anuradhaa]

Got it, just remove the - mark infront of aggr