View Single Post
  #2   Report Post  
Domenic
 
Posts: n/a
Default

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!