Please see the attached spreadsheet. I have people's names in cells A2:A5. These names have a rank value in cells B2:B5. What I would like to do is create a formula that sorts/orders the names in cells A2:A5 according to the rank in cells B2:B5. The results I would like to achieve are shown in A8:A11.
I am aware of the "Sort" function in the "Data" drop down menu, but need to leave cells A1:B5 as they are. Suggestions welcome.
Bookmarks