Solved How do I write a Rank function for the following (POST 1)

February 11, 2015 at 18:04:46
Specs: Windows 7
Rank values from C4:C39 to be recorded in cells A4:A39, then if there are any values the same, rank next from cells D4:D39 and then finally from cells E4:E39 if required.

See More: How do I write a Rank function for the following (POST 1)

Report •


#1
February 12, 2015 at 04:59:25
If you do a google search for something like Excel rank multiple criteria you'll get lots of hits.

Here is one example that might work for you...

http://www.mrexcel.com/forum/excel-...

If you can't find a solution, please post an short example of your data and we'll see if we can help further. Please click on the following link before posting example data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 12, 2015 at 16:00:20
The following function appears to work for first two criteria but not the third.
Can you help ?.

COUNTIF($D$4:$D$39,">"&D4)+1+SUMPRODUCT(--($D$4:$D$39=D4),--($E$4:$E$39>E4),--($F$4:$F$39>F4)))


Report •

#3
February 12, 2015 at 17:50:30
✔ Best Answer
Google is your friend.

Check out the file available in post #3 of this thread:

http://www.excelforum.com/excel-gen...

The 3rd tab of the sheet ranks players using 3 criteria, which I believe is the exact outcome you are looking for.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question