View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kittronald kittronald is offline
external usenet poster
 
Posts: 162
Default SMALL function to find X smallest number greater than Y

*** CORRECTION ***

I didn't word this problem correctly, so forget the A1:A4 range.

If you were to create a formula that resulted in =SMALL({0,0,10,20},
2), how could you get the result to be 20 ?

Is there a way to replace the zero values with text and then use the
SMALL function ?


- Ronald K.