Here is my previously posted formula in a little simpler format...

=RANK(A1,A$1:A$20)&IF(SUMPRODUCT(--(RANK(A$1:A$20,A:A)=RANK(A1,A:A)))1,"."&SUMPRODUC T(--(RANK(A$1:A1,A:A)=RANK(A1,A:A))),"")

And, of course, change the A$20 reference to the last cell of data you have.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
I can get you part way to what you asked for. You request is for 1, 2, 3.1,
3.2, 4... the 4 is the problem with my formula below... it will give the
next item after the 3.1 and 3.2 the rank of 5 (because the 3.1 and 3.2 take
the place of the 3/4 tie, so the next rank after them is 5, not 4). If that
is OK, here is the formula...

=RANK(A1,A$1:A$15,TRUE)&IF(SUMPRODUCT(--(RANK(A$1:A$11,A$1:A$15)=RANK(A1,A$1:A$15)))1,"." &SUMPRODUCT(--(RANK(A$1:A1,A$1:A$15)=RANK(A1,A$1:A$15))),"")

--
Rick (MVP - Excel)


"MichaelZ" wrote in message
...
Could someone provide a duplicate ranks with decimal fractions algorithm.
I
need to rank data that has tied values, but I want a ranking that is
unique
for each value, so I need to rank the data using decimals, (eg., 1, 2,
3.1,
3.2, 4, etc.).
Thanks in advance