# dynamic list needs a dynamic sort

1. ## dynamic list needs a dynamic sort

I have a dynamic list (the INPUTS):

A B
1 34 135
2 22 30
3 199 37

I am looking formula to do a dynamic sort of C low to high, so that (the OUTPUT):
C D
1 22 30
2 34 135
3 199 37

Can anyone help?

Thanks.

2. ## Re: dynamic list needs a dynamic sort

Will there ever be duplicate values in column A?

What version of Excel does this have to work in?

no

2013

thnx

4. ## Re: dynamic list needs a dynamic sort

Try this...

Data Range
 A B C D 1 34 135 22 30 2 22 30 34 135 3 199 37 199 37 4 ----- ----- ----- -----

Enter this formula in C1:

=SMALL(A\$1:A\$3,ROWS(C\$1:C1))

Enter this formula in D1:

=VLOOKUP(C1,A\$1:B\$3,2,0)

Select C1:D1 and copy down as needed.

5. ## Re: dynamic list needs a dynamic sort

Fantastic. thank you Tony!

6. ## Re: dynamic list needs a dynamic sort

You're welcome. Thanks for the feedback!

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

There are currently 1 users browsing this thread. (0 members and 1 guests)