Need help to fill up Rank table

[Sanjibghosh]

Hi Everyone,

I need help to fill up this table by formula. But i can't understand how to solve it.

[BlindAlley]

In C3 use =RANK(B3,$B$3:$B$23,0)+COUNTIF(B3:B$3,B3)-1

In D3 use =OFFSET(A$3,MATCH(SMALL(C$3:C$23,ROW()-ROW(A$3)+1),C$3:C$23,0)-1,0)

Fill down both columns then use a simple non formula 1 to 20 in E3:E23

Pay attention to where the $ references are.

[Phuocam]

Try this ...

In F3:

=LARGE($B$3:$B$23,D3)

In E3 **:

=INDEX($A$3:$A$23,LARGE(IF($B$3:$B$23=F3,ROW($B$3:$B$23)-2,""),COUNTIF($F$3:F3,F3)))

**Array formula, enter with Ctrl+Shift+Enter.

[Sanjibghosh]

Thanks BlindAlley and Phuocam

[Phuocam]

You're welcome!