Sort a list of furmulated data

  • Thread starter Thread starter J Kaarela
  • Start date Start date
J

J Kaarela

I need help sorting a list of calculated data. I have a
list of teams in column A and their points totals in
column B. The points totals are obtain through a formula
from other data cells.

What I need to do is sort the teams and their total points
from highest totals to lowest.
 
J Kaarela said:
I need help sorting a list of calculated data. I have a
list of teams in column A and their points totals in
column B. The points totals are obtain through a formula
from other data cells.

What I need to do is sort the teams and their total points
from highest totals to lowest.
Click to expand...

Select columns A and B.
Data > Sort > Sort by column B descending > OK

This assumes that your formulas are written properly - that is, that they do
not depend on the RELATIVE position of other data. If sorting alters the
points totals, you need to revisit the formulas to achieve this.
 
Back
Top