Something like:

OFFSET($O$6,COUNT($O$6:$O$1000)-1,0)

--

Vasant




"ijyoung" wrote in
message ...

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