L
Legacy 386498
Guest
Hi all,
I was wondering if it's possible in Excel to automatically rank numbers from highest to lowest? So in this example, you see that the numbers go from 5 to -1, but if I were to change the -1 to 6, Excel would automatically change the list so that cake is first, candy second and chocolate last. Is that possible?
Sure, I could add a line above, add column headers and filter them from highest to lowest each time the numbers change. But I was wondering, could Excel always update itself without me doing anything?
Thanks.
<tbody>
</tbody>
I was wondering if it's possible in Excel to automatically rank numbers from highest to lowest? So in this example, you see that the numbers go from 5 to -1, but if I were to change the -1 to 6, Excel would automatically change the list so that cake is first, candy second and chocolate last. Is that possible?
Sure, I could add a line above, add column headers and filter them from highest to lowest each time the numbers change. But I was wondering, could Excel always update itself without me doing anything?
Thanks.
Candy | 5 |
Chocolate | 2 |
Cake | -1 |
<tbody>
</tbody>