How to arrange a number of cells

[tucker91]

I have 9 columns with Data:

Team
Wins
Losses
Points scored
Points allowed
Location Strength
Bonus 1
Bonus 2
Total score

the total score has a formula that uses data from each cell and comes up with a calculation.

Can I somehow order the teams from highest number(based off of total score calculation) to lowest? will it reorder all of the cells? Or maybe can I have it list the team name from highest to lowest in another row/column?

 

[SteveInAus]

As long as you highlight all the Columns and then sort by the column you want, all Columns/data will go with the sort, and each row will keep their correct data