|
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 |
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 |
| All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com