# rank name

#### normg

##### New Member
Hi
Hope someone can help. As an example, In A2:A4 I have names ie
John, Dave and Sam, and in E2:E4 I have the corresponding rankings. Is it possible, that if Dave is ranked 1 his NAME (Dave) is placed in cell H2 and if john is ranked 1 next time, his name (John) is placed in cell H2 in place of Dave, and so on?
Hopes this makes sense

Norm

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Norm

Is this what you want? Formula in H2 (copied down):
=INDEX(A\$1:A\$4,MATCH(ROWS(H\$2:H2),E\$1:E\$4,0))
Mr Excel.xls
ABCDEFGHI
1NameRankNames in Rank Order
2John3Dave
3Dave1Sam
4Sam2John
5
Rank

What I am hoping to achieve is to only have the no1 ranking placed in H2 each time. So as Sam is ranked no1, only Sam is placed in column H, cell H2.

Hope this helps

Norm

What I am hoping to achieve is to only have the no1 ranking placed in H2 each time. So as Sam is ranked no1, only Sam is placed in column H, cell H2.

Hope this helps

Norm
In that case just delete the formulas I suggested from H3 and H4 and leave the one in H2. Actually you could simplify the H2 formula to:
=INDEX(A\$1:A\$4,MATCH(1,E\$1:E\$4,0))

How did you determine the ranks in E2:E4 - using a formula? If so, care to post that formula?

Perfect Peter

Norm

Replies
5
Views
108
Replies
3
Views
287
Replies
2
Views
440
Replies
1
Views
173
Replies
7
Views
173

1,203,605
Messages
6,056,269
Members
444,853
Latest member
sam69

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back