How to return the first X numbers from a range list?

**LIVIA** · 11-19-2009, 02:35 PM

HI,
I attached a quick excel file, where I explian the help I need!!

I want to know if there is a simple way (no macro need) of select from a list of numbers (already shuffled) the 1st "X" amount numbers, that belongs to a pre-determined range.
It is easier to see the file, than try to explain.

Can anyone help me pls!!
Thanks

**NBVC** · 11-19-2009, 02:44 PM

Try:

=IF(COUNT($D$5:D5)>13,"",IF(AND(B6>=$B$2,B6<=$C$2),B6,""))

copied down

**DonkeyOte** · 11-19-2009, 02:46 PM

If you want the list devoid of blanks (ie consecutive) then given the numbers in B are seemingly unique

Please Login or Register  to view this content.

**NBVC** · 11-19-2009, 02:59 PM

Or you can use C as a helper column just to determine which numbers fall in the range, with formula:

=IF(AND(B6>=$B$2,B6<=$C$2),MAX($D$5:D5)+1,"") copied down

then, to get the list of 13 separately and with no blank rows between, use formula

=INDEX($B$6:$B$165,MATCH(ROWS($A$1:$A1),$D$6:$D$165,0))

copied down 13 rows.

and if you are going to want a separate list with no blanks,... you probably would want the numbers sorted.. so an additional formula next to the last one would be:

=SMALL($F$1:$F$13,ROWS($A$1:$A1))

copied down (where F1:F13) contains the Index/Match formula above...

Those columns could be hidden, if desired and only show the final result of 13 sorted numbers...