Forum Discussion
Solved
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 |
Hi Padideh
To help others who search this site please mark HansVogelaar 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)) ) )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.
