Rank by value and date?

Originally Posted by bobboy

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.

Hi,

add the date /10000 to the number (format the display to hide the fraction) and rank the conglomerate, you can also add Row()/1000000 to split any further matches.

hth
---