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...
=INDEX($C$2:$C$21,MATCH(MIN($B$2:$B$21),$B$2:$B$21,0))If you want the cell with the smallest value index other info you can try INDEX and MATCH.