Rank Dates with Continuous Rank and no Tiebreaker

[njkollauf]

Hey guys,

I am having some trouble with ranking dates. I want to rank a data set in ascending order. With dates there could be a multitude of ties. Is there a way to rank the dates and keep the number rolling up based off order in the list being the "first"?

Ex:

Using "=RANK($K2,SoftDates,1)+(COUNTIF($K$2:$K1000,$K2)-1)"

The Data looks like this:

Soft Rank	Soft Date
2	8/25/2015
9	9/2/2015
3	8/28/2015
3	8/28/2015
4	8/31/2015
4	8/31/2015
4	8/31/2015
4	9/2/2015
4	9/2/2015
2	8/25/2015

<tbody>
</tbody>

When the ranks should actually look like this:

Soft Rank	Soft Date
1	8/25/2015
8	9/2/2015
3	8/28/2015
4	8/28/2015
5	8/31/2015
6	8/31/2015
7	8/31/2015
9	9/2/2015
10	9/2/2015
2	8/25/2015

<tbody>
</tbody>

 

[njkollauf]

The issue is that the rank formula doesn't take into account that the Rank 3 has always been used because another paid of data already used it for ranks 3 and a so what used to be rank 3 in the list now really should rank 5 and its matching partner should rank 6

 

[shg]

Row\Col	A​	B​	C​
1​	Soft Rank​	Soft Date​	​
2​	1​	08/25/2015​	A2: =RANK(B2, $B$2:$B$11, 1) + COUNTIF(B$1:B1, B2)
3​	8​	09/02/2015​
4​	3​	08/28/2015​
5​	4​	08/28/2015​
6​	5​	08/31/2015​
7​	6​	08/31/2015​
8​	7​	08/31/2015​
9​	9​	09/02/2015​
10​	10​	09/02/2015​
11​	2​	08/25/2015​

 

[njkollauf]

Solved. My named ranges had wrong absolute references. I went with the Rank.EQ function too. Thanks!

 

[shg]

You're welcome.