LARGE function with variable K argument

Hi,

I have a large file of data, an excerpt of which is shown in columns A to D of the attached file.

In column G I have calculated and ranked in descending order the relative values. Can someone please tell me how to make the “k” argument in the LARGE function dynamic so I don’t need to type into the formulae 1 for the first ranked result, 2 for the 2nd etc and can also take account of a changing number of rows.

Thanks!

hi andrewc. probably this?
=ROWS(G$2:G2)

so:
=LARGE((((1+$B$2:$B$5/100)/(1+$C$2:$C$5/100))-1)*100,ROWS(G$2:G2))