Excel - Sort calculated values.
How do I sort a table eg to league positions on points when points are a calculation result?
Select all the data you want to sort and Data/Sort and follow the Wizard.
If you want to do this automatically after each calculastion I think you'll need a macro.
This thread is now locked and can not be replied to.