lowest 10 cells of last 20 greater than 0

P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SMALL function to find X smallest number greater than Y 6
INDEX MATCH SMALL 13
Countif with two criteria 2
Findiing highest and lowest in rows and columns 3
Need help with a formula 3
Formula 3
Extract the 2 Lowest % 3
Staggered filter on Excel 0

Top