Is there function that returns MIN (or MAX) cell reference

I think the title more or less asks the question. record short post for me. something that looks like =CELL.MIN(reference)

thanks

brian

I'm looking to return the Cell Reference for the cell in a range that has the minimum value.

The MIN function returns that value. But if it is from a range of 24000 cells and i want to find that value, it would be nice to be able to return the cell reference as well. Conceivably also something like MIN with more arguments e.g. MIN(type, reference) where type means type of return and maybe 1 is value, 2 is cell reference for value, etc.


this is for truthing a list i downloaded and some values come back as 0 or anomalously low. I can use the find command and go look for the value but getting the settings right in so far as case matching, etc.

But even if the values weren't anomalous, someone might want to move quickly to outliers in a list, so ditto for MAX.

thanks,

brian