How can I rank numbers based on other numbers?

N

NoelMouse

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.
 
B

Biff

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return a value if item does not appear on list 1
Finding a Name on a list and returning all matching rows 2
How can the font and size of (all) citation numbers be altered? 1
How can I combine two formulas Left/Mid/Right + Substitute? 7
Count based on 2 conditions 4
CountIf on not number values. How can I solve? 4
How can I use both RANK and MATCH 2
Can these look ups be done using Worksheets functions 6

Top