Have set up an array to arrange competitors in order of finishing.
=OFFSET(A$6,MATCH(SMALL(O$6:O$10,ROW()-ROW(P$6)+1),$O$6:$O$10,0)-1,0).
Need to be able to change "O$10" to match the number of entries.
Wotya say guys?
Ian
--
ijyoung
------------------------------------------------------------------------
ijyoung's Profile:
http://www.excelforum.com/member.php...o&userid=26154
View this thread:
http://www.excelforum.com/showthread...hreadid=394800