How can I rank numbers based on other numbers?

G

Guest

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
CountIf on not number values. How can I solve? 4
Ranking based on frequency 2
IF problem using Solver 5
How can I "RANK" time in Excel 2003? 7
How to speed up code 4
Dropping duplicate records based on content 2
Can I display fields from different records in one window in a for 2

Top