98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Updating a League Table
Updating a League Table
Resolved · Medium Priority · Version 2003
Wed 4 Aug 2010, 13:13Delegate David said...
David has attended:
Excel Advanced course
Excel Advanced course
Updating a League Table
Hi Anthony,
Further to our discussion at the training course on Friday, could you tell me how you update a league table automatically in Excel, without the need to manually cut and paste rows so that the person with the higest score is at the top and the lowest score is at the bottom?
I would like to create a league table that upon a new score being attributed to each person, the league table will update the ranking order automatically?
For example:
James - 325
Tom - 336
John - 316
Peter - 349
Mark - 322
I look forward to hearing from you.
Kind Regards,
David
Tue 10 Aug 2010, 11:10Trainer Anthony said...
RE: Updating a League Table
Hi David, thanks for your query and apologies for the delay in getting back to you. There's no way to sort automatically on the same worksheet without using macros. However, have a look at this link:
http://exceltemplate.net/sports/create-your-own-soccer-league-fixtures-and-table/
The download contains a workbook with separate worksheets which, when updated correctly cause the league to be reordered automatically. The formulas don't use much more than IF and VLOOKUP statements so you should be able to cannibilise it to what you need, if nothing else you can just replace the team names!
Hope this helps,
Anthony
Tue 17 Aug 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Status Bar FunctionsWhen using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet. |
