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...
List of Names and Birthdays:
- In column A, list the names of people.
- In column B, list their corresponding birthdays.
Add Dynamic Ranking:
- In column C, you can add a ranking formula that dynamically ranks the sorted names based on birthdays. Use the RANK function:This ranks the birthdays in ascending order (1 for the oldest), assuming your data goes from row 2 to row 100. Adjust the range according to your actual data.excel=RANK(B2, B$2:B$100, 1)
Example:
Name Birthday Rank
| PersonA | 1/1/1991 | 1 |
| PersonB | 1/2/1991 | 2 |
| PersonC | 1/3/1991 | 3 |