The best approach depends - if you have direct entry of the values, you could have an event macro that sorts the table every time you change a value.

Or if you use formulas to extract the values (based on another table), you could use formulas to sort the values too, except you need to address possible ties and how to break them.