P Peo Sjoblom Jul 21, 2003 #2 Something like this =SMALL($A$10000:INDEX($A$1:$A$10000,LARGE(ROW(INDIRECT("1:10000"))*($A$1:$A$ 10000>0),20)),ROW(1:1)) entered with ctrl + shift & enter, copy down 10 rows will give you the smallest, second smallest and so on Change the dimensions ( I used 10000 rows) to fit your list since the larger array the slower calculation
Something like this =SMALL($A$10000:INDEX($A$1:$A$10000,LARGE(ROW(INDIRECT("1:10000"))*($A$1:$A$ 10000>0),20)),ROW(1:1)) entered with ctrl + shift & enter, copy down 10 rows will give you the smallest, second smallest and so on Change the dimensions ( I used 10000 rows) to fit your list since the larger array the slower calculation
