Dear All,

I wan a formula to "detect" who have the highest mark amount the whole
score table.

Test 1 Test 2
Jo 56 55
Mark 98 06
Simon 89 57
Stella 88 58
Jean 50 51

I wan a Formula to show:

Highest sco Mark, Test 1
Lowest sco Mark, Test 2