Forum Discussion
CELL Function with a MIN formula as a reference
Is there a way to find the cell that a MIN formula is referencing? Tried using the CELL function's "address" info type, but it results in an error. The MIN formula I'm using is huge, and I'm trying t...
From what I read about CELL, it won't do what you want to do. However, assuming your MIN is referring to a range of cells (either a column or a row), something like this can work to find--in this case--the row within the designated array.
=MATCH(MIN(F7:F11),F7:F11,0)
And with that you could index other things from the same row in a two-dimensional array. (Assumption: only one cell in the full array contains that MIN value....