Top 5 numbers from N number of rows for different entity

[TanvirQoS]

Top 5 number from N number of rows.png

Hi please go through the following and would be great if anybody share the solution.(Top 5 rows for respective entities,If entity row count<5 then ranking for all row against that entity)

Entity Value Top 5 rank value
A 14
A 9.4
A 23.2 3
A 11.2
A 17 5
A 23.4 2
A 21 4
A 2
A 55 1
B 34.4 1
B 4 4
B 22.4 2
B 11.3 3
B 2 5
C 2
C 12 2
C 5
C 8 5
C 1
C 12 2
C 23 1
C 7
C 11 3
C 10 4
C 6
D 5 2
D 2 3
D 12 1

[TanvirQoS]

please check the attahment for better understanding

[Ace_XL]

With your data in A1:B28

use in C1
=IF(SUMPRODUCT(($A$1:$A$28=A1)*($B$1:$B$28>B1))+1>5,"",SUMPRODUCT(($A$1:$A$28=A1)*($B$1:$B$28>B1))+1)

Copy down