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...
Let's say the dates of birth are in A2:A100.
In the rank column, enter the following formula in row 2:
=RANK.EQ(A2:A100, A2:A100, 1)
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:
