OK. Scrap that! It doesn't work. If all values, but 1, are 36 and one is < 36... it falls over.
An alternative:
1. Kill zeros, use blanks.
2. excluded max value (array)
=MAX(E5:N5+COLUMN(E5:N5)/10^10)
3. Low scores (array):
IFERROR(SMALL(IF($E5:$N5<>$S11,IF($E5:$N5<>"",$E5:$N5)),T$4),"")
I think it's OK now!!
Bookmarks