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:

	A	B
1	Shash	40
2	Yog	10
3	Yog	10
4	Avi	10
5	Ran	80
6	Shash	50
7	Raj	5
8	Raj	2

<tbody>
</tbody>

Output:
Result must be

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

	D	E
	Name	Top 3 total scores
Rank 1	Shash	90
Rank 2	Ran	80
Rank 3	Yog	20

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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).