Bernd P, you have too many helper columns.

Try this formula "No helper columns are required"

=INDEX($B$1:$B$6,MATCH(1,($C$1:$C$6=MIN(IF($A$1:$A $6=A1,$C$1:$C$6)))*($A$1:$A$6=A1),0))

ctrl+shift+enter, not just enter



"Bernd P" wrote:

Hello,

Gary''s Student's solution does not show the correct result if
different classes have the same minimum or if a minimum of one class
appears at a lower row number for another class.

Enter 78 into cell C1, for example.

My suggested correction:
Array-enter into D1
=A1&"|"&MIN(IF($A$1:$A$100=A1,$C$1:$C$100,""))
and copy down.
Array-enter into E1
=MATCH(D1,$A$1:$A$100&"|"&$C$1:$C$100,0)
and copy down.
Enter normally into F1
=INDEX(B:B,E1)
and copy down.

The old solution in F1 would do but I would never use OFFSET if I can
use INDEX because OFFSET is volatile and INDEX is not.

Regards,
Bernd

PS: Use non-volatile INDEX(P11:IV65536,1+w,1+y):INDEX(P11:IV65536,w+y,x
+z)
instead of volatile OFFSET(P11,w,x,y,z).