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.

If you do a google search for something like Excel rank multiple criteriayou'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.

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)))

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.

Ask Your Question

Weekly Poll

Do you think Salesforce should have bought Slack?

Discuss in The Lounge

Poll History