Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I find the minimum NONBLANK value in a sequence of cells?
|
#2
![]() |
|||
|
|||
![]()
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? |
#3
![]() |
|||
|
|||
![]()
=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 |
#4
![]() |
|||
|
|||
![]() "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
minimum for casual cells but 0 | Excel Discussion (Misc queries) | |||
find all cells that match and use in an index/vlookup | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
How to find cells with links to other workbooks? | Excel Discussion (Misc queries) |