| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
expanding range to reflect entries
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to compute StDev of only nonzero entries in a range? | Excel Worksheet Functions | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
| count no. of entries in range for a day | Excel Worksheet Functions | |||
Linear Mode
