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:
[TABLE="width: 171"]
<tbody>[TR]
[TD]Soft Rank[/TD]
[TD]Soft Date[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8/25/2015[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9/2/2015[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8/28/2015[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8/28/2015[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]8/31/2015[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]8/31/2015[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]8/31/2015[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9/2/2015[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9/2/2015[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8/25/2015[/TD]
[/TR]
</tbody>[/TABLE]

When the ranks should actually look like this:
[TABLE="width: 171"]
<tbody>[TR]
[TD]Soft Rank[/TD]
[TD]Soft Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]8/25/2015[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]9/2/2015[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8/28/2015[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]8/28/2015[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]8/31/2015[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]8/31/2015[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]8/31/2015[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9/2/2015[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]9/2/2015[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8/25/2015[/TD]
[/TR]
</tbody>[/TABLE]

 

[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]

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr][tr][td]

1​

[/td][td]

Soft Rank​

[/td][td]

Soft Date​

[/td][td]

​

[/td][/tr]
[tr][td]

2​

[/td][td]

1​

[/td][td]

08/25/2015​

[/td][td]A2: =RANK(B2, $B$2:$B$11, 1) + COUNTIF(B$1:B1, B2)[/td][/tr]
[tr][td]

3​

[/td][td]

8​

[/td][td]

09/02/2015​

[/td][td][/td][/tr]
[tr][td]

4​

[/td][td]

3​

[/td][td]

08/28/2015​

[/td][td][/td][/tr]
[tr][td]

5​

[/td][td]

4​

[/td][td]

08/28/2015​

[/td][td][/td][/tr]
[tr][td]

6​

[/td][td]

5​

[/td][td]

08/31/2015​

[/td][td][/td][/tr]
[tr][td]

7​

[/td][td]

6​

[/td][td]

08/31/2015​

[/td][td][/td][/tr]
[tr][td]

8​

[/td][td]

7​

[/td][td]

08/31/2015​

[/td][td][/td][/tr]
[tr][td]

9​

[/td][td]

9​

[/td][td]

09/02/2015​

[/td][td][/td][/tr]
[tr][td]

10​

[/td][td]

10​

[/td][td]

09/02/2015​

[/td][td][/td][/tr]
[tr][td]

11​

[/td][td]

2​

[/td][td]

08/25/2015​

[/td][td][/td][/tr]
[/table]

 

[njkollauf]

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

 

[shg]

You're welcome.