Thread: SMALL function to find X smallest number greater than Y
View Single Post
  #1   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
How can you find the X smallest number in a range that is greater than
Y ?

For example, return the second smallest number in the range A1:A4 that
is greater than 0.

A
1 0
2 0
3 10
4 20

The result should be 20.

Any ideas ?


- Ronald K.
Reply With QuoteReply With Quote