Are there any Excel gurus here???

I control the points for a championship and have everything adding up nicely at each round as race points are added…. But then have to resort each class into order once the points are input.

Is there a clever formula of some sort that can auto sort 10 or so riders into order by the points total column ( which is calculating by adding race points together ) as the values change?.

Any ideas people ?

There is an auto filter with sorting options built into Excel 2007 onwards.

http://m.wikihow.com/Use-AutoFilter-in-MS-Excel

Alternatively create a form to enter the results and have that do a sort when they are submitted.

or record a macro of the process