mardi 10 août 2021

How to find cell address in a table/range with nth value in Google Sheets

I need a formula that will output the cell address of the nth value in the table/range shown in the image. The range is an output of x/y variables that will be continuously changing. So the nth value, as well as its row/column address, will always be changing as well.

I have used =large(D39:N60,1) to output the nth (1) value of the range, but have not been able to combine with any other functions to output the cell address.

Output of x/y variable calculations

Aucun commentaire:

Enregistrer un commentaire