MAX Value and OFFSET?

[Tinä]

Hi Aladin,

Picked up correction.

Thanks
Tinä

message
=INDEX(Test_Score,MATCH(MAX(INDEX(Test_Score,0,2)),INDEX(Test_Score,0,2),0),1)

I'd like the following correction:

The formula in D2 should be replaced with:

=MAX(IF(INDEX(B4:B7,MATCH(D1,C4:C7,0))=B4:B7,C4:C7))-D1

which must be conformed with control+shift+enter instead of just wit
enter