Forum Discussion
Solved
How to RANK, but changing the number of components being ranked automatically
I am trying to Rank a column using the following formula: =((RANK(AS4,$AS$3:$AS900)/number_of_stocks)*100), however instead of the $AS900 component, I would like to vary the number of cells being...
hi rick01
You can use offset() function to manage cell ranges. I have used below formula in attached sample file.
=IFERROR(RANK(B3,OFFSET($B$3:$B$196,0,0,$E$4,1)),"")
Input required row number in E4 and let men know if is works as desired.
Thanks
Tauqeer
Great - works perfectly! You saved me a lot of time !
You’re welcome