Thread: finding minimum value excluding zero
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
bookman3 bookman3 is offline
external usenet poster
  
Posts: 25
Default finding minimum value excluding zero
Thanks a lot
--
bookman


"JMB" wrote:

Assuming the data is in A1:A10, try:

=MIN(IF(A1:A10<0,A1:A10))
array entered using Cntrl+Shift+Enter

or
=SMALL(A1:A10,IF(COUNTIF(A1:A10,"<0"),1,COUNTIF(A1 :A10,0)+1))


"bookman3" wrote:

Hi

I have a list of values including zeros. How can I find the minimum value in
the list that is greater than zero.

Regards
--
bookman
Reply With QuoteReply With Quote