# Data Ranking not Working!

#### xp252

##### New Member
Hi there, long time reader, first time poster.

I am having trouble getting this equation to work correctly:

"=INDEX(B:B,MATCH(MAX(LARGE(N:N,1)),N:N,0))".

I have names in Column B and scores in Column N. The equation does correctly displays the highest score of Column N. However, it does not work correctly if two of the scores are the same.

Column B Column N
John 89
Jacob 91
Max 82
Ben 91
Sam 85

First Place: Jacob
Second Place: Jacob (this should be Ben if Jacob is first place)
Third Place: John

Does anyone know what I'm doing wrong?

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Replies
12
Views
439
Replies
1
Views
799
Replies
0
Views
310
Replies
1
Views
531
Replies
0
Views
390

1,191,232
Messages
5,985,425
Members
439,964
Latest member
nparrillo

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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