Want formula to automatically sort column A and B by column B into column C

[stiga00]

Hello all,

I am seeking a solution for a something that I feel should be easy but continue to struggle. I have 2 columns of data. column A is a name, column b is a number. I want column C and D to automatically sort the data from A and B by the numbers in Column B in Decending order.

[JohnTopley]

in C1 (or wherever data starts)

=INDEX(A$1:A$100,MATCH(LARGE($B$1:$B$100,ROWS($1:1)),$B$1:$B$100,0))

Copy across to D and then down

[stiga00]

Boom! that it is it. Still learning about INDEX and MATCH functions. Thank you so so much.

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.