In Excel, how do you get something to move position depending on its numberic value?

  • 0 votes

In my excel spreadsheet I have to make a leauge table, I was wondering how I would make the teams move up and down depending on how many points they have in the current leauge? can anyone help me? 

Posted Fri 27th April, 2012 @ 17:54 by Char'Rose

1 Answer

  • 0 votes

you could use an "if" statement to change the order of the numbers by linking the teams directly to the cells. then create the if statement that puts them in an order of largest to smallest.

Answered Sat 28th April, 2012 @ 12:50 by melvin