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" colum...
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.