Rank Duplicates Based on Other Cell Value - Part 2

[Drogan]

I would just like to say thank you to jasonb75 and Peter SSs for helping me with my last problem. However, now I have a new problem. Previously, I wanted to rank duplicate scores based on highest dropped value. The new problem is using both the lowest and highest dropped values for duplicate scores.

So say for example the highest dropped values were both 9.9 and the lowest dropped values were 6.7 and 7.2. I would need the scores to be based on both sets of values at once.

For more information, see original thread (Part 1) here: http://www.mrexcel.com/forum/showthread.php?p=2685661

You can see the setup of the scores and the working formulas posted by jasonb75 and Peter SSs. I went with jasonb75's array formula: {=INDEX($B$1:$K$1,SUMPRODUCT(--($B$9:$K$9=B31),--($B$6:$K$6=(LARGE(IF($B$9:$K$9=B31,$B$6:$K$6),COUNTIF($B$31:B$31,B31)))),COLUMN($A:$J)))}

Now I just need to include the lowest dropped values but I can't figure out how I need to modify the formula accordingly based on the example given. Any help would be greatly appreciated. Thank you.

 

[Drogan]

Well, I figured it out after playing around with it a bit longer. All I had to do was include the lowest value row with the highest value row. So it became $B$2:$K$2*$B$6:$K$6 instead of just $B$6:$K$6.