Never mind , when we don't know, then we ask...this is the quickest way to get knowledge, isn't it?
I also am like you ha ha...
To explain what you ask, when you see "IA:IA" in my code, it is the temp range that I use to calculate, then after calculation is done, I clear them with the code Range("IA:IC").clearcontents...by the way this new alternative much more easier for you...
Now I design the formula, but is need 3 more columns to use the last column in the right, to avoid any use cell in you spreadsheet, they are column IA,IB and IC.
To get the result we need 4 steps..
1) I think that If we rank with 2 criteria, both are number, then number1+number2, no matter what the number are, the ranking will reflex out correctly. Then in column IA I input the formula =Q2+T2....simple like this
2) Now to arrange the number in IA, I use function small() then the formula is =LARGE($IA$2:$IA$10,ROW()-1)...then our data will be sort by Highest value to lowest one.
3) then in Column IC I assign the ranking with the formula =IF(IB1="Sort",1,IF(IB2=IB1,IC1,IC1+1))
to check if the value in IB= text "Sort" we know that this is the first number then we put 1 in the cell
But if else we check that the cell in the left equal to the above cell of it, then assign the same number (number above)
then if the the cell in the left is not equal to the above cell of it, then assign that same number+1
4 finally use Vlookup() to get the ranking to our area =VLOOKUP(IA2,IB:IC,2,0)
Hope this is more easy for you....