Numbering the data

How to create a serial number that shown on the results column in the attachment below by using formula? Thank you for advance who can help me

Cell E2: =B2&D2&RANK($C$2:$C$7,C2)+COUNTIFS($B$2:$B$7,B2,$D$2:$D$7,D2,$C$2:$C$7,"<"&C2), copy down.

Thank you everyone

You're Welcome. Thank You for the feedback