Formula problem, get and sort numbers between two values

[Michaelice]

Hi!
I have been trying and searching all day for a answer but i can't get it to work.
I got a list of uniqe values like this:

10003
10001
10002
20001
20003
20002
30002
30001
30003

I start the values with different numbers to be able to split them up in differente classes
and I need get one of the classes and sort them in descending order.

I've been trying and almost got it to work with this code.

Please Login or Register  to view this content.

But I would need something like this so I can get a single class and sort it.

Please Login or Register  to view this content.

I would be really happy for some help here.
Thanks in advance!

[Jacc]

Like this you mean?

Note that these are array formulas. Has to be entered with Ctrl+Shift+Enter.

[Michaelice]

Yes, exactly like that!
Thanks so much for the solution and so fast answer!

[Tony Valko]

Try this...

Data in the range A2:A10

Use cells to hold the boundaries:

C2 = 20000
D2 = 30000

Then, this array formula** entered in E2:

=IFERROR(SMALL(IF(A$2:A$10>C$2,IF(A$2:A$10<D$2,A$2:A$10)),ROWS(E$2:E2)),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

[Michaelice]

Thanks!
Both solutions worked perfect for me!

[Tony Valko]

You're welcome. We appreciate the feedback!

[Jacc]

Glad to hear it worked!
If there is a limited number of data and ranges then Autofilter and copy paste will do the same jobb for you without the hassle of array formulas.