## Forum Discussion

DanWebtronx

Sep 06, 2022Copper Contributor

# 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...

DanWebtronx

Copper Contributor

Unfortunately, that assumption is incorrect, and the MIN value occurs more than once. Thanks for the suggestion though.

mathetes

Sep 06, 2022Silver Contributor

Yes...my first reply was clearly crossing the exchange you had with another similar reply. Reading your MIN formula--you said it was "huge" but that was an understatement!!!!!!!!--makes me wonder how the data are arrayed in the first place, and whether or not there's a way to reorganize it.

That aside, are you familiar with the relatively new FILTER function? Without knowing how your data are arrayed, this may totally miss the mark, but perhaps FILTER, in conjunction with the MIN function could at least find the row(s) that contain that MIN value.

Here's a link to a good resource of FILTER.

- DanWebtronxSep 06, 2022Copper ContributorIt's organized in a way that one could paste up to 30 vendor lists into one sheet. Each one is separated so we can distinguish which vendor the list is from. I'm just surprised there isn't an obvious way to reference the data of a MIN formula beside matching.

I can't figure out the FILTER function would give me the row or column the minimum value is found.