Sort a list of furmulated data

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.
 
P

Paul

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top