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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
=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))
 
Dave Peterson said:
=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))
Click to expand...


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