sandmania,

Have your tried Data / Sort? Select the whole table, and the rows will stay together when you sort
based on one column.

If you want to create a second table that contains the same data as the first, but just sorted, then
it's a bit more complicated, but easily do-able.

Let us know....

HTH,
Bernie
MS Excel MVP


"sandmania" wrote in message
...
Hi,
I have a worksheet with data in several rows. Column wise they consist of
names, points etc..

I am trying to setup a formula whereby the formula looks at the data in the
points columns and then re-orders the rows accordingly taking all the
information in the row with it, with the highest points total at the top and
lowest points total at the bottom.

Each points cell, has a formula in there already which pulls the points
total from other cells and combines them.
Hope you can help!
Thanks