Rank number within Group in Excel

[Padideh]

Hello everyone, I have this dataset and I want to rank peoples score in each Group, but I want to same score have same rank, also I dont want to skip number. finally I want Somthing like "Rank" column.

Thank You :)  @cuong 

Group	Person	Score	Rank(What I want)
A	Peter.J	12	2
A	Young	11	3
A	Mj.lan	2	4
A	Didan.v	2	4
A	Pandas	3	5
A	Landa	33	1
B	Jack	3	4
B	Numes	12	3
B	Peter jackson	15	2
B	John	12	3
B	Anne	18	1
C	Channel	12	2
C	Angelina	20	1
C	Sijal	20	1
C	David	12	2
C	Jonete	9	3
D	Burak	19	1
D	Faherie	7	2
D	Valaa	7	2
D	Manely	19	1

[#2]

@Padideh 

Shouldn't Mj.lan and Didan.v have rank 5, and Pandas have rank 4?

If so, in D2:

=SUM(IF(($A$2:$A$21=A2)*($C$2:$C$21>=C2),1/COUNTIFS($A$2:$A$21,A2,$C$2:$C$21,$C$2:$C$21)))

If you don't have Microsoft 365 or Office 2021, confirm with Ctrl+Shift+Enter.

Then fill down.

[#3 · Accepted solution]

Yes you are Right.

It works! I Cant thank you enough, I really appreciate your Help :)

@Hans Vogelaar  

[#4]

Hi @Padideh 

To help others who search this site please mark @Hans Vogelaar post as solution (link at the bottom of his reply) - Thanks

If you run 365, a dynamic array alternative:

=MAP(A2:A21, C2:C21,
    LAMBDA(Grp,Scr,
        SUM(--(UNIQUE(FILTER(C2:C21, A2:A21=Grp)) >= Scr))
    )
)