SOLVED

New Contributor

# Rank number within Group in Excel

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
3 Replies

# Re: Rank number within Group in Excel

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.

best response confirmed by Padideh (New Contributor)
Solution

# Re: Rank number within Group in Excel

Yes you are Right.

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

# Re: Rank number within Group in Excel

``````=MAP(A2:A21, C2:C21,