expanding range to reflect entries

I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple table lookup 12
Index and Match 8
Deleting/Clearing duplicate range of cells 4
Double Match - version 2 5
Double Match 6
Sum-Count-Offset-IF- Match 6
duplicate name help please 9
lotto numbers 2

Top