Sort (Data - Sort) the table on the Pts column and select Descending. HTH
Otto
"Bishop8910" wrote in message
...
i need a Formula to rearrange a table with the highest points first this is
my table:

Team Position Pld Pts W L D GD
Reading HFC 5 0 0 0 0 0 0
Razzers Reapers 3 1 3 1 0 0 1
Fenland Flyer 1 4 10 3 1 0 -1
Unison Sheffield Steelers 4 2 2 0 2 0 -3
Koenigs-Bier HC 1 4 10 3 1 0 3
any one have any ideas ?