Hello!
I search a number with maximum value in column "B", let's say, this number is siuated in cell "B5".
Now I have to retrieve the contents of a cell situating left from "B5": contents of cell "A5". If maximum value would always stand at cell "B5" I could easily use function OFFSET.
But if I change data in column "B", maximum value's address will change. How can I retrieve the contents of cell situating in the left column from the dynamic cell "BX" where X is a row number that may change?
Thanks!