| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANK Function
I'm sure there is an easy way of doing this ...
I have a list of data values that I want to rank in terms of the nearest/furthest away from zero. Some of the values are positive and some are negative. How do I use RANK such that No 1 is the value (positive or negative) that is nearest to zero, No 2 is next nearest, etc? Many thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with RANK function | Excel Worksheet Functions | |||
| using RANK function | Excel Discussion (Misc queries) | |||
| Rank function | Excel Worksheet Functions | |||
| Rank Function | Excel Worksheet Functions | |||
| Rank Function | Excel Discussion (Misc queries) | |||
Threaded Mode
