Try...
=CELL("row",INDEX(C6:C11,MATCH(MIN(C6:C11),C6:C11, 0)))
Hope this helps!
In article ,
"Stan" wrote:
I'm trying to locate a cell based upon certain criteria. For example:
=CELL("row",min(C6:C11)). What doesn't seem to work is using the Min
function. Any thoughts on the best way to return a cell location?
Many thanks for any help you can provide!
|