View Single Post
  #4   Report Post  
codeslinger
 
Posts: n/a
Default How do I find the minimum NONBLANK value in a sequence of cell



"Dave Peterson" wrote:

=min(a1:a10)

=min() will ignore text and empty cells.

Or if you want to be extra careful:

=if(count(a1:a10)=0,"No numbers",min(a1:a10))



codeslinger wrote:

How do I find the minimum NONBLANK value in a sequence of cells?


--

Dave Peterson



Actually, I worded my question poorly. But your answers helped me to figure
out how to do what I wanted. Thanks for the replies.