| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I rank negative and positive numbers?
I rank numbers. Some of them are negative and some of them positive. The
ranking works fine for positive numbers. However, it gives me ranks of 20,22 and so on for negative numbers. I hope I can get either a modification of a ranking formula or another formula. Please help, Anna |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add only positive numbers and avg in a column | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| Erf (the error function) for both negative and positive numbers | Excel Discussion (Misc queries) | |||
| can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
| Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
Threaded Mode
