Ranking - How skip to avoid duplication

[Paul Naylor]

Hi I've got a list of colleagues Column A A2-A35 and a list of no of errors they have made.

Rank in column H Rank 1,2,3,4,5
Rank volume in column I
Rank Name in Column J

RANK Volume formula :LARGE($B$2:$B$32, H3)

Rank Name Formula : =INDEX($A$2:$A$32, MATCH(LARGE($B$2:$B$32, H3), $B$2:$B$32, 0)

Problem is there are a number of colleagues with the same number of errors, but formula only picks up the 1st occurance of the one who has the ranked volume , so 2nd person is showing under 2,3 and 4th Rank and the last person is showing as the 5th Rank. As the data set gets bigger there should be some variation but now just need some way if multiple colleagues have same number of errors either displaying all their names or substituting the Colleague name for the volume of the errors e.g. Rank 1 volume 4 . 3 colleagues

 

[Marcelo Branco]

See if this example helps

Pasta3
	A	B	C	D	E	F
1	Names	Errors		Rank	Large	Name
2	Name1	5		1	10	Name10
3	Name2	8		2	9	Name5
4	Name3	2		3	9	Name7
5	Name4	8		4	8	Name2
6	Name5	9		5	8	Name4
7	Name6	7
8	Name7	9
9	Name8	6
10	Name9	6
11	Name10	10
Plan10

Cell Formulas
Range	Formula
E2:E6	E2	=LARGE(B$2:B$11,D2)
F2:F6	F2	=INDEX(A$2:A$11,AGGREGATE(15,6,(ROW(A$2:A$11)-ROW(A$2)+1)/(B$2:B$11=E2),COUNTIF(E$2:E2,E2)))

Try to adapt it to your real case.

M.