| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rank with condition
I need to use the rank function to get the position of each item in a list based on its corresponding Revenue. However, the range
that has the revenue numbers also contains a percentage related to that item. Basically, I need to use RANK based on a list that ignores any elements which are <= 1. Any ideas?? Thx in advance ! -- RMC,CPA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rank where lowest value is highest rank | Excel Worksheet Functions | |||
| RANK formula | Excel Discussion (Misc queries) | |||
| How can I rank numbers based on other numbers? | Excel Worksheet Functions | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
| Rank fx - Fill Down? | Excel Worksheet Functions | |||
Threaded Mode
