Thread: 2nd lowest Value in Array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default 2nd lowest Value in Array
One way

=SMALL(IF(A1:A10<0,A1:A10),2)

needs to be entered with ctrl + shift & enter


--
Regards,

Peo Sjoblom


"Dale" wrote in message
...
I need to return the 2nd lowest value in a contiguous number array but I
want
to exclude zero values, how can I write this formula?


Reply With QuoteReply With Quote