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...
Type: Posts; User: FlameRetired
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...