Does anyone know how to rank a list by a number and date simultaneously with a formula thus eliminating duplicate rankings? I tried some things like ranking separately then adding the two rank values but the values I get with the dates don't seem to work very well. Could sort but want to keep the same chronological order and highlight the lower ranked rows with conditional formatting. If I have three values at 9 and the formatting threshold is 10, I get 11 rows highlighed.