( by )
Have a look at the following screenshots:
Sheet1 is having only Data and no formulas..
I have the following formula in Cell B1 of Sheet2:=query('Sheet1'!A:R;"select A,R where A<>'' order by R desc";1)
And the following formula in Cell A1:
The above two formulas generate the rankings on Sheet2.
Note: First insert formula in Cell B1 and then insert the formula in Cell A1.
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.