How to automatically re-order a list
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
|