Hi all.
Is there a way I can get my total data to automatically sort in descending order so as I fill in data into say B3(5 in the table below) the sheet updates accordingly.
---A---B---Total
---2---1----3
---2---5----7
should automatically sort to
---A---B---Total
---2---5----7
---2---1----3
it doesn't matter what order they are in if there are 2 totals that are the same as long as they are sorted in descending order.
Thanks for any help.
Bookmarks