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:
<tbody>
</tbody>
When the ranks should actually look like this:
<tbody>
</tbody>
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>