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.
|