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.

Aucun commentaire:
Enregistrer un commentaire