I need to find the max of values located in cells with changing addresses. I am trying to use a combination of MAX and ADDRESS command but get an error message.
=MAX(ADDRESS(L3,M3):ADDRESS(N3,M3))
Here I am trying to find a maximum among numbers located in the range of cells (address of which is specified according to numbers in cells L3,M3 and N3)
Kindly help