| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I rank numbers based on other numbers?
I'm trying to rank user's cell minutes of use based on what account they fall
under, and if they are on a particular plan. Here is an example of the information. cell # MOU plan Acc# 555-1234 12 Nation 1200 1111111 555-1235 10 Nation 1300 1111111 555-1236 5 Nation 1200 2111111 555-1237 4 Nation 1300 2111111 555-1238 15 Nation 1200 1111111 I want to be able to rank the user based on the minutes of use (MOU), plan, and account #. I know that I need to use some form of an array formula, but I cannot seem to figure out how to get it correct for the Rank function. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
| Sum numbers based on the contents of another cell | Excel Worksheet Functions | |||
| how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
| Can I assign a rank based on a cells' value | Excel Worksheet Functions | |||
| Rank() based on category | Excel Worksheet Functions | |||
Threaded Mode
