Hi,

This can only ever be an approximation, but the following should give you
something to work with.
Assuming your truncated data is in A1:A20, enter the following in B1 and
drag down

=A1+(COUNTIF($A$1:A1,A1)-1)/COUNTIF($A$1:$A$20,A1)

or use

=A1+(COUNTIF($A$1:A1,A1)-1)/COUNTIF($A$1:A1,A1)

for a slightly different set of numbers

Dave

url:http://www.ureader.com/msg/10355706.aspx