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 2.

However, I also want to be able to remove someone from the list and have their rank replaced. So, if PersonA was removed, then PersonB would automatically move from rank 2 to rank 1.

Currently, I am using the =MAX(A$2:A2)+1 function where the ranking cell starts in A3 but I can’t figure out how to “tie” the rank to the rest of the information in the filtered table. Right now, when I sort the table the rank does not tie in despite being part of the table filter

​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 2. However, I also want to be able to remove someone from the list and have their rank replaced. So, if PersonA was removed, then PersonB would automatically move from rank 2 to rank 1. Currently, I am using the =MAX(A$2:A2)+1 function where the ranking cell starts in A3 but I can’t figure out how to “tie” the rank to the rest of the information in the filtered table. Right now, when I sort the table the rank does not tie in despite being part of the table filter  Read More

​