top 10 formula

[JLARAG1210]

Good Afternoon Team!!

noob here with a question regarding ranking. i have a list of names with scores next to it, the scores constantly update and most of the time they are repeated. i've been trying to use the rank.eq formula but it only serves half of the purpose. it tells me which ones are the ones with the highest score as advertised but in another sheet i would like to have the top 10. i've tried using vlookup but since the rank.eq formula instead of listing the rank from 1-10, it lists 1, 1, 1, etc.. if the first place is tied. the vlookup formula then only lists the first name that has the highest score rendering it useless. any assistance would be greatly appreciated.

Thank You in Advance

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[Sam Capricci]

in the absence of a workbook (Pepe's recommendation by the way) this is a handy little formula to break ties in a rank.
=RANK(A1,$A$1:$A$10,0)+COUNTIF($A$1:A1,A1)-1
assumes your data is in col A beginning in cell A1, adjust the location and range accordingly. And BTW, this is for ranking descending.
hope that helps.

[JLARAG1210]

Good Morning,

Thank You for the reply, I tried using the formula and it only gave me a partial answer. It works wonders but is there a way to have the score and the name show up? I tried using vlookup but it only works if there are no repeated scores. any assistance would be greatly appreciated.

I've attached a small sheet for further explanation.

Thank you all in advance

[Glenn Kennedy]

In G4:
=INDEX(C:C,AGGREGATE(15,6,ROW($C$4:$C$33)/($D$4:$D$33=H4),COUNTIF($H$4:$H4,$H4)))

In H4
=LARGE($D$4:$D$33,F4)

both copied down.

[JLARAG1210]

Thank You so much, that worked wonderfully. I had once tried working this out myself and it took 4 helper rows and several other functions. This is so much better. Thank You so much

[Glenn Kennedy]

You're welcome and thanks for the rep.