SOLVED
Home

Excel - Matching different column names to Ranks

MuzzyB
New Contributor

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.

2 Replies
Solution

Hi,

You should be able to copy the following formula into cell "A2" of your 'Ranking Losses' tab...

=INDEX(Scenario!A:A,MATCH(C2,Scenario!G:G,0),0)

 

If you want to check it's working...  

first just copy the above formula into cell "A2" then copy THAT CELL and paste that formula into cells "A12" and "A18", the results should continue to show '4' and '22' respectively.

Otherwise you can just FILL the formula down.

 

All this assumes that your column "G" in the 'Scenario' tab is only set to display 2 decimal places and not rounded to show DPs. I've included a spreadsheet for info.

 

Hope that helps.
Regards
N

Perfect. Thankyou very much.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies