INDEX MIN function?
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).
|