Hello, I'm having an issue trying to find a minimum value. What I'm attempting to do is have a formula output the cell coordinates of this minumum value and then use those coordinates to return the data in the row below the minimum value.
What I have right now is a formula that returns the coordinates of the minimum value of a row =CELL("address",OFFSET(A1,0,MATCH(MIN(A1:N1),A1:N1,0)-1)) and it outputs $[ROW]$[COLUMN]. I would like to take the $[ROW]$[COLUMN] coordinates and use a formula to output the data contained in the cell $[ROW-1]$[COLUMN]
Does that make any sense? Is it possible?
Bookmarks