Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
codeslinger
 
Posts: n/a
Default 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?
  #2   Report Post  
Paul B
 
Posts: n/a
Default 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?



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default 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
  #4   Report Post  
codeslinger
 
Posts: n/a
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
minimum for casual cells but 0 realspido Excel Discussion (Misc queries) 2 October 22nd 05 02:48 PM
find all cells that match and use in an index/vlookup Adam Bell Excel Discussion (Misc queries) 1 October 21st 05 07:41 PM
Display first, second, etc Nonblank Cells in a Range Jeremy N. Excel Worksheet Functions 12 September 25th 05 02:47 PM
How can I find and format specific cells automatically in Excel? Amy Excel Worksheet Functions 1 August 6th 05 04:00 PM
How to find cells with links to other workbooks? Bathonian Excel Discussion (Misc queries) 1 December 21st 04 10:55 AM


All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"