Assumptions:

A2:A6 contains the name

B1:C1 contains the column header/label

B2:C6 contains the data

Formula:

Let E2 contain 'Highest Sco' (just a label)

F2:

=INDEX(A2:A6,MIN(IF(B2:C6=MAX(B2:C6),ROW(B2:C6)-ROW(B2)+1)))&",
"&INDEX(B1:C1,MATCH(MAX(B2:C6),INDEX(B2:C6,MIN(IF( B2:C6=MAX(B2:C6),ROW(B2
:C6)-ROW(B2)+1)),0),0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. For the lowest
score, replace MAX with MIN.

Hope this helps!

In article ,
Will wrote:

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