lowest 10 cells of last 20 greater than 0

  • Thread starter Thread starter kush
  • Start date Start date
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
 
Back
Top