Excel Experts Please Help

[shatzia]

Hi everyone,
I would love someones help with some formulas or perhaps even charting.
Attached is our workout challenge excel form. Every week competitors will be putting in a score for a workout. Every week will be a different form of score whether it be rounds, time, a weight. But the best score will be assigned a place so the person who has the best score would get 1st, second best score 2nd etc. People who did not finish the workout will get a DNF which means they did not finish. They will still be in the standings but will not be allocated any points based on that workout.

Could someone help in providing a way to make standings where every workout once someone is announced first or second etc the spread sheet will automatically rank the competitiors.
Any help with making this spreadsheet better would be amazing.

It will be extremely motivating if I send the girls a really good spreadsheet.

Thanks in advance for all your help!!

[Special-K]

You really need to read the rules

http://www.excelforum.com/forum-rule...rum-rules.html

especially the first one

[FDibbins]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.