THANKS TO ALL WHO WERE KIND ENOUGH TO PROVIDE ANSWERS... MY ISSUES WITH THIS SPREADSHEET ARE RESOLVED :>)
I sincerely hope I titled this post correctly! I probably spent more time trying to ensure I did this right than actually writing the post :oops:
I have a drill meet scoresheet that will be a 'master' sheet for recording all of the results of each schools' performance in several events. Each event has 3 scores/school and their total for that event. In the last column we want to have the RANKING (automatically) of each school based on that total for that event (ex: 7 schools... so it would rank them 1 thru 7 -- but not change the physical order on the sheet.)
THEN, after all events, we need to see the ranking of each school based on ALL TOTALS OF ALL EVENTS. We would like the rankings to update automatically as we enter the data from each event.
If this isn't clear, I have the file and would be glad to provide it to anyone if you want it (or tell me what you need and I'll do it if I can.
I would really appreciate help with this as I know it's something I should be able to do, but just can't quite "get it".
Thanks in advance!
Maggie