I have a dilemma. So basically I have a column for scenarios and a column for losses. To show the losses ranked from worst to best, I had to format it and change the settings, but now this leaves my scenario column not matching up, and was wondering is there a formula to sort it? I have seen all the match functions etc, but they're not the one. I shall attach a screenshot below.
The first file will contain the scenario's by the losses in the original form, and the second file will contain the losses ranked from worst to best, without the scenario's column filled in.