Forum Discussion
rt2963
Jan 19, 2025Copper Contributor
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 A3 and 8 in cell A4.
In another cell I have the formula MAX(a1:a4) and that will return 10 which is the largest number in the array. I would like to know if there is a function I can use to return the reference of the cell instead of the value so that the formula would return $A$2 or whichever cell contained the largest value in the array.
For example:
=ADDRESS(XMATCH(MAX(A1:A4), A1:A4), 1)
- rt2963Copper Contributor
Thanks.