My worksheet is basically a track and field data handler.
I want to make the following
HEAT 1(as a page heading)
LANE(column heading=ch) CONTESTANT(ch) SCHOOL(ch) TIME(ch) PLACE(ch)
The lane, contestant, and school will be entered beforehand. Time will be entered at the time of the race. Can I then make excel choose between all the times and assign/display a place(ex. 1st-8th) to each time?
Thanks in advance for all the help
MORE QUESTIONS TO COME LATER!!!
Last edited by Rhett19; 01-27-2011 at 05:29 PM.
The following code will sort the data out for you. It's not to hard I attached the finished spreadsheet below. If you know VBA maybe you could help me :D
Please Login or Register to view this content.
Thanks to forum member who told me about =RANK().
Last edited by RPickering2; 01-27-2011 at 05:05 PM.
Download above spreadsheet do you want something like that?
I've made changes just need to do some more formula.
Last edited by RPickering2; 01-27-2011 at 04:10 PM.
The dropdown menu is not a must, but pretty cool!!! Can you expand the worksheet. When I expand it to a full field, i only get 1st and 2nd and it doesnt even pick the lowest for first.
Sorry if i didn't explain myself very well
I have attached what i did if it helps
I've updated my spreadsheet just re-download that top post it now does first and second for the first to places.
Please have patience with me I'm only 17 and new to excel.
If you want to contact me i'll pm you my msn.
I'm just not very savvy with the new excel, i can only do simple formulas
I dont think "IF" will work because you have multiple sets of data. I'll google some other methods and try.
Thank you so much
Have a look at the RANK() function in Excel Help.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you ^ google wasn't showing me nothing.
I have completed it for you. Any other questions PM me or jut make another thread on here. Please go to the second post and re download. I think if Solved your problem you are ment to change it to SOLVED in the advanced settings.
If you make the range part absolute by adding the $ signs, then you only enter it once and copy down:
=RANK(F2, $F$2:$F$9)
Also, please don't edit previous posts, just continue adding posts with replies, so that everyone can more easily follow what is going on.
Ah I was wondering that. I'll edit for him/her.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks