Data is vertically aligned, containing dates (formatted as mm/dd/yyyy) within the range BG68:BG213. Rank values are returned in each row, offset to Column BH.

In this example, assume that the nearest date to today is shared by two instances; thus the =RANK returns a 1 for both, skips 2 and applies a 3 to the next newest date.

I would like to have the 2nd instance of the 1 be a 2 and am happy to disregard the logic behind which of the two data points get the 1 and which gets the 2. Whichever occurs first in the vertical range gets the 1.

I believe the following could be of assistance, I'm just struggling with the application.

Link: http://www.excelforum.com/excel-work...s-in-rank.html

Thanks!