Dear all,
I have tried to display result for the top 3 rider for each stage in the Results Page tab for each individual stage. The data needs to come from Stage Results. I tried using Index and Match but to no avail despite using {}. Any help much appreciated.
Thanks
k992010,
wouldn't you use something like...
=INDEX(Riders,MATCH(1,INDEX((Stage=ThisStage)*(Scores=LARGE(INDEX((Stage=ThisStage)*(Scores),),1)),),0))
Just change the red 1 to be a 2 for 2nd place and a 3 for 3rd place
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi Tigeravatar....looks like this got posted twice....I like your solution...mine was Index/Match but not as elegant as yours....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
@judgeh, I didn't see that this was a duplicate thread, ah well. Your solution worked with OP's data setup, whereas mine would require that the data structure be changed. Props to you for making it work with OP's data setup as is though
@tigeravatar ---- Thanks
Thank you everyone for their help. You are all life savers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks