Auto sort a column

It is possible, and some on this forum will likely know how to do it more simply than I, but here is how I do it. I have a sheet that I call "calculations" where I compile that data, then I do a rank on it using this rank formula (so it gets rid of ties) =RANK(A2,$A$2:$A$1000,0)+COUNTIF($A$2:A2,A2)-1.
Then I put another column of numbers, say 1-10 (or more) in ascending order then do a vlookup on them referring to the results of the ranks. A couple steps but it works for me.

EDIT: Oh and that final area is where I point my graph so it always stays in order based on the ranks.

see attachment for example.

Great! Glad I could help.
Don't forget to mark your thread as solved (in the blue bar at the top of the thread under thead tools) and reputation points are always appreciated by those who helped.

EDIT, thanks for the rep points.

Sorry, I was in a mtg for the last 90 minutes.
see attached for how I would do it.
BTW, the vlookup I used in col AB is a reverse vlookup formula, I'm told index and match would be the way most would do that but I've never gotten index and match to work for me.

Also BTW (edit): it should manage to continue to resort the results based on changes to your rolling data provided you don't have to continue to change parameters.