Forum Discussion

Padideh's avatar
Padideh
Copper Contributor
Oct 01, 2022
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...
excel
  • Padideh's avatar
    Padideh
    Oct 01, 2022

    Yes you are Right.

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

    HansVogelaar  

Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 03, 2022

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))
    )
)

Resources