Forum Discussion
Returning a cell reference.
I've searched through all the Excel functions and can't seem to find a way to return a cell reference from a formula if that makes sense. For example. I have 5 in cell A1, 10 in cell A2, 4 in cell ...
For example:
=ADDRESS(XMATCH(MAX(A1:A4), A1:A4), 1)
Thanks.
