Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |