Thread: 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" <codeslinger@discussions.microsoft.com> wrote in message
news:69AD1DAE-BC84-47BF-8A0F-F56D2EAFD316@microsoft.com...
> 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

"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.