See if this old post helps:

http://tinyurl.com/gpsaa

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"pADDY qUIGLEY" wrote in message
...
I have a chart which shows total score for teams 1 to 9. Can Excell sort,
so
that the teams are automaticaly sorted into asending ordr. i.e team B has
1000 points team A has 750, so team B should go automatically to the top
of
the sheet and team A directly below.

Thanks