+ Reply to Thread
Results 1 to 6 of 6

dynamic list needs a dynamic sort

  1. #1
    Registered User
    Join Date
    07-22-2004
    Posts
    89

    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. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    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?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    07-22-2004
    Posts
    89

    Re: dynamic list needs a dynamic sort

    no

    2013

    thnx

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    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. #5
    Registered User
    Join Date
    07-22-2004
    Posts
    89

    Re: dynamic list needs a dynamic sort

    Fantastic. thank you Tony!

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: dynamic list needs a dynamic sort

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA auto sort a dynamic list with formulas
    By Schrankwand2006 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2013, 06:32 AM
  2. [SOLVED] Dynamic sort with dynamic sort criteria
    By david.herrera1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2012, 11:06 AM
  3. Macro to sort dynamic list into table
    By Andy748 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2008, 08:13 PM
  4. A macro to sort a dynamic list
    By alis88 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-10-2008, 06:32 PM
  5. Dynamic Sort
    By etsusurveyor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2007, 04:38 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1