Hello Peter,

Then try:
B1 (enter as array formula with CTRL + SHIFT + ENTER):
=IF(SUMPRODUCT(--(ABS($A$1:$A$8-A1)<=$D$1))=1,A1,INDEX($A$1:$A$8,MATCH(1,--(ABS($A$1:$A$8-A1)<$D$1),FALSE)))

C1 (enter normal again):
=RANK(B1,$B$1:$B$8,TRUE)

D1:
0.02

and copy B1:C1 down again.

BTW: My former suggestion works if your numbers are rounded to the same
result - no matter how many numbers are rounded to the same. You just
have to find the "right" rounding accuracy (in your counterexample it
should be 0.026, I think).

Regards,
Bernd