Locate a Cell based upon criteria
 

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!

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!