Formula help Please !!!
 

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 ?

Formula help Please !!!
 

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 ?

Formula help Please !!!
 

i need it to do it automaticly when i up date the table, so im not sure how
to do that ?

"Otto Moehrbach" wrote:

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 ?

Formula help Please !!!
 

Why? Why is it so difficult to do the sort?

If you want it done automatically, you will need to record a macro. But you will
still need to invoke the macro, which will be almost as much work as doing the
sort.

--
Regards,
Fred


"Bishop8910" wrote in message
...
i need it to do it automaticly when i up date the table, so im not sure how
to do that ?

"Otto Moehrbach" wrote:

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 ?

Formula help Please !!!
 

Are the points always positive integers ?
--
Regards,
Luc.

"Festina Lente"


"Bishop8910" wrote:

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 ?