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