Forum Discussion
Ranking Names in Excel
Hi all, Looking for a way to attach a ranking to a name based on birthday. For example, if PersonA was born 1/1/1991 and PersonB was born 1/2/1991 then PersonA would rank 1 and PersonB would rank...
HansVogelaar is there a way to do this with no duplicates? For example if two people had the same birthday, they are not both ranked #5
How would you like the ties handled?
I see two approaches: HansVogelaar 's solution with RANK.EQ or using XMATCH.
=XMATCH([@DOB],SORT(UNIQUE([DOB])))
It really depends on how you'd like the duplicates (and birthdays after the dupes) handled: