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.
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.
Will there ever be duplicate values in column A?
What version of Excel does this have to work in?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
no
2013
thnx
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.
Fantastic. thank you Tony!
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
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)
Bookmarks