Dear all,

I've a table of three columns, namely : Name, Class & Score.

Peter 3A 17
Mary 3B 14
Sam 2A 13

So, in the next session, if Mary's total score is more than Peter's, then
Mary's row of record will jump from row 2 to row 1 and Peter's row will
descend one row down automatically (i.e.without pressing the sort button).
My question is what formula/function should I enter so that the row sequence
can jump in accordance with the total score of each person. Please advise.

Thanks in advance.