| 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. |
|
#2
|
|||
|
|||
|
Hi!
RANK is not a very flexible function and won't handle conditional arrays. You'd have to separate the data into the individual groups and then rank each group. Biff "NoelMouse" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
