With a staging row inserted above data and a staging column (B) beside data
with formula:
=IF(A2-A1<=$E$1,A1,A2)

See example: http://cjoint.com/?fjqWglx47b

HTH
--
AP

"Peter Gundrum Milwaukee WI"
a écrit dans le message
de news: ...
30.12
30.13
30.50
30.75
30.89
30.90
31.00
32.00

Say I had the list of numbers above. I would like to find a fairly easy
way
to rank that list like this.

1) 30.12
1) 30.13
3) 30.50
4) 30.75
5) 30.89
5) 30.90
7) 31.00
8) 32.00


30.12 and 30.13 are so close together I would like to give them the same
rank. Same with 30.89 and 30.90. Is there an easy way to do this?
Also I
would like to be able to vary the closeness. In this example I gave
anything
within .01 the same rank. But I would like to be able to vary that,
anywhere from .01 all the way up to 2.0 or whatever. Thanks very much
for
any help you can give me with this.

Peter Gundrum
Milwaukee