Posts by airbisglenn

that did it! thank you so much for you time and help!

when I try that i changes rank to date all ending with 2000?

any excell way to change rank numbers base on the birthday, i.e if both ar ranked at 201 the one with the elearst birthday would remain 201 and the tie would go to 202 and so on?

sorry i thought I had added column with birthday, added now with sample dates

we only use month and day to brake tiesSample of ranking.xlsx

Sample of ranking.xlsx

the problem I am having is breaking ties using the birthday month and day, ranking working good but have tie that i can't seem to fix?

Have problem in ranking, been getting lots of ties, rank formula works great off date but need to add tie breaker using birthday month and day?

added count if but could not figure it out?

currently using =RANK(C5,C$5:C$976,1)Sample of ranking.xlsx

put conditional format on attachment so you can see all the ties

thank you