Automatic Sorting for a newbie

[wakkoguy]

I have two columns, one with names the other with values from 1-50
the numbers match up with the names like a ranking system for example:

bob 2
rachel 1
jenny 4
jim 3
etc.

I want excel to automatically sort these into
rachel 1
bob 2
jim 3
jenny 4

Does that makes sense?

the names are already entered but a user enters the numbers in
different sheet. I have it set to pull the numbers but i want
seperate column to sort them into ascending order without having to d
it manually everytime.
thanx

 

[Jim May]

Why create a third column C and enter in C2 = A2 & " " & B2 and copy
down;
Then just continue to sort by Column B (the Ranking ascending).
Just a thought...

 

[Tom Ogilvy]

In another column, assume C1
=Index($A$1:$A$50,Match(row(),$B$1:$B$50,0),1)

then drag fill down the column.