does anyone know of an efficient way to rank 10 values and place them in descending order. for example, there are 10 teams in a league and at the end of the season they've accumulated points based on their performance. however, as they are listed now they are not in order from 1st to 10th place. i just want to be able to hit a button (or better yet, maybe there's a formula I could type in a cell) and have them displayed in order from 1st to 10th. any ideas?
Bookmarks