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

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

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

codeslinger, =MIN(A1:A10), Min will ignore blank cells if you have a number
in one cell
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"codeslinger" wrote in message
...
How do I find the minimum NONBLANK value in a sequence of cells?

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

=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

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.