Need formula of ranks of students(Names are repaated) based up on the sum of scores.

[JOHN007]

Let us say i have list of students and score against each student. (Name of student may\may not repeat. i the list of top 3 students(Rank) and sum of scores against each student.


Input:
[TABLE="width: 596"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Shash[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Yog[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Yog[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Avi[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Ran[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Shash[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Raj[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Raj[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


Output:
Result must be

I need a formula in D2,D3,D4, E2,E3,E4

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl78, width: 64"][/TD]
[TD="class: xl77, width: 64"]D[/TD]
[TD="class: xl77, width: 64"]E[/TD]
[/TR]
[TR]
[TD="class: xl79, width: 64"] [/TD]
[TD="class: xl79, width: 64"]Name[/TD]
[TD="class: xl79, width: 64"]Top 3 total scores[/TD]
[/TR]
[TR]
[TD="class: xl79, width: 64"]Rank 1[/TD]
[TD="class: xl79, width: 64"]Shash[/TD]
[TD="class: xl79, width: 64, align: right"]90[/TD]
[/TR]
[TR]
[TD="class: xl79, width: 64"]Rank 2[/TD]
[TD="class: xl79, width: 64"]Ran[/TD]
[TD="class: xl79, width: 64, align: right"]80[/TD]
[/TR]
[TR]
[TD="class: xl79, width: 64"]Rank 3[/TD]
[TD="class: xl79, width: 64"]Yog[/TD]
[TD="class: xl79, width: 64, align: right"]20[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...t-order-top-bottom-preferrabally-top-5-a.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).