Rank Duplicate Values Sequentially

Question

Hello there, 

please i need some support with a rank formula to consider the duplicated values

i used this function to rank my value

=IFERROR(INDEX($A$2:$A$13,MATCH(LARGE($B$2:$B$13,D2),$B$2:$B$13,0)),0)

but as shown, the 1st 2 leaders are duplicated as per the duplicated match criteria, therefor it must result "Abdullah Team" then "Islam Mokhtar Team" of the opposite  

thanks a lot,

Answer 1

Hi,

Put this formula in E1 and then drag down.

=INDEX($A$2:$A$100,MATCH(LARGE(INDEX($B$2:$B$100+(ROWS($B$2:$B$100)-ROW($B$2:$B$100))/10^5,0),ROWS($1:1)),INDEX($B$2:$B$100+(ROWS($B$2:$B$100)-ROW($B$2:$B$100))/10^5,0),0))

Answer 2

Use a helper column C.

Put following formula in C2 and drag down -

=IFERROR(RANK(B2,$B$2:$B$13)+COUNTIF($B$2:$B2,B2)-1,"")

Put following formula in E2 and drag to right for F2 (and drag down)

=IFERROR(INDEX(A$2:A$13,MATCH($D2,$C$2:$C$13,0)),"")