Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
RANK and CORRELATION | New Users to Excel | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) |