+ Reply to Thread
Results 1 to 6 of 6

Sort extracted data in descending order

Hybrid View

  1. 07-24-2012, 01:03 PM #1
    Aland2929
    Aland2929 is offline
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Sort extracted data in descending order

    I have two drop-down lists - one for month & one for town. I use SUMIFS to extract data. Is there a way I can automatically sort the extracted data in descending order? I have attached a sample file.
    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-24-2012, 01:47 PM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Sort extracted data in descending order

    Perhaps...in a separate table below..using INDEX & MATCH functions
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 07-24-2012, 02:00 PM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sort extracted data in descending order

    Or with a pivot table.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  4. 07-24-2012, 01:59 PM #4
    bonny24tycoon
    bonny24tycoon is offline
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: Sort extracted data in descending order

    Have attached the sheet with my macros...

    I have added a macro and a private sub under sheet1.. try it out TestFile.xlsm
    Thanks,

    Bonny Tycoon

    Reply With QuoteRegister To Reply
  5. 07-24-2012, 02:47 PM #5
    Aland2929
    Aland2929 is offline
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Re: Sort extracted data in descending order

    Thanks so much for all your help. They all work great.
    Reply With QuoteRegister To Reply
  6. 07-24-2012, 03:14 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Sort extracted data in descending order

    Glad I could help. Thanks for the reply.

    If the question is solved, will you mark your question as solved?

    If you have (other) questions, just ask.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1