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