Automatic Sorting for a newbie

W

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
 
J

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...
 
T

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.
 
Top