Good one.

Also try this one that I got from Bob Umlas:


=INDEX(mylist,MATCH(SMALL(COUNTIF(mylist,"<="&mylist),ROWS($1:1)),COUNTIF(mylist,"<="&mylist),0))

It must also be committed with...