Rank lowest to highest with tie breaker

[doctorcpu]

I'm trying to create a formula to rank the following from lowest to highest with a tie breaker. So far I've come up with this:
=RANK(X2,X$2:$X21,0) but it does not work and does not account for a tie.

Column X
[TABLE="width: 77"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]0.17[/TD]
[/TR]
[TR]
[TD="align: right"]3.33[/TD]
[/TR]
[TR]
[TD="align: right"]2.50[/TD]
[/TR]
[TR]
[TD="align: right"]0.83[/TD]
[/TR]
[TR]
[TD="align: right"]0.58[/TD]
[/TR]
[TR]
[TD="align: right"]3.33[/TD]
[/TR]
[TR]
[TD="align: right"]1.00[/TD]
[/TR]
</tbody>[/TABLE]

Any help is appreciated.

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Value​

[/td][td="bgcolor:#F3F3F3"]

Rank​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

0.17​

[/td][td="bgcolor:#CCFFCC"]

1​

[/td][td="bgcolor:#CCFFCC"]B2: =RANK(A2, $A$2:$A$8, 1) + COUNTIF(A$1:A1, A2)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

3.33​

[/td][td="bgcolor:#CCFFCC"]

6​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

2.5​

[/td][td="bgcolor:#CCFFCC"]

5​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

0.83​

[/td][td="bgcolor:#CCFFCC"]

3​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

0.58​

[/td][td="bgcolor:#CCFFCC"]

2​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]

3.33​

[/td][td="bgcolor:#CCFFCC"]

7​

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

 

[doctorcpu]

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #C0C0C0"][/TD]
[TD="bgcolor: #C0C0C0"]

A​

[/TD]
[TD="bgcolor: #C0C0C0"]

B​

[/TD]
[TD="bgcolor: #C0C0C0"]

C​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

1​

[/TD]
[TD="bgcolor: #F3F3F3"]

Value​

[/TD]
[TD="bgcolor: #F3F3F3"]

Rank​

[/TD]
[TD="bgcolor: #F3F3F3"][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

2​

[/TD]
[TD]

0.17​

[/TD]
[TD="bgcolor: #CCFFCC"]

1​

[/TD]
[TD="bgcolor: #CCFFCC"]B2: =RANK(A2, $A$2:$A$8, 1) + COUNTIF(A$1:A1, A2)[/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

3​

[/TD]
[TD]

3.33​

[/TD]
[TD="bgcolor: #CCFFCC"]

6​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

4​

[/TD]
[TD]

2.5​

[/TD]
[TD="bgcolor: #CCFFCC"]

5​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

5​

[/TD]
[TD]

0.83​

[/TD]
[TD="bgcolor: #CCFFCC"]

3​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

6​

[/TD]
[TD]

0.58​

[/TD]
[TD="bgcolor: #CCFFCC"]

2​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #C0C0C0"]

7​

[/TD]
[TD]

3.33​

[/TD]
[TD="bgcolor: #CCFFCC"]

7​

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks