expanding range to reflect entries

[ijyoung]

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?

Ia

 

[Vasant Nanavati]

Something like:

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