returning a cells address based on a formula?

[Dave]

I have a data range of a1:d5 with sales figures. I have determined the
lowest value using =MIN(A15).
What I need to know is what cell contains that lowest value (is it a3
or b2 or d4, etc.).
The =CELL("address",min(a1:d5)) does NOT work. Any idaes?
Thanks, DAVE

 

[Bernie Deitrick]

Dave,

I should have noted that this formula may fail if the minimum value is not
unique (and if one of the duplicate values has a higher row and lower column
than the other....).

The formula can be fixed to check for duplicate minimums and return an error
rather than a possibly incorrect address, if that is a concern.

HTH,
Bernie
MS Excel MVP