This is what I have. A spreadsheet that will take the times from a track meet(4 heats, 8 contestants per heat). So far I have each heat as i want them(put in times and they get ranked from 1st to 8th in each heat). I need to know how to take all 32(or whatever number of contestants there are) and put them in the RANKED RESULTS from lowest time to highest time. Then it should, using the RANK function rank them from 1-32. I need to know how to get there times, names, and school into the RANKED RESULTS. Once this is done I want to take the fastest 8 and move just their names and school into the FINALS. Then the contestants will run another race and their times will be put into the appropriate spot and these will be ranked(which I think I have done).
Bottom Line: Get the contestant info from the first 4 heats into the ranked results and then taking the top 8 and putting them into the finals.
Attached is my progress thus far:
Thanks in advance.
If any further information is needed, please ask. Hopefully I explained myself thoroughly.
Bookmarks