+ Reply to Thread
Results 1 to 4 of 4

Arranging in Descending Order & Faster Solving

  1. #1
    Registered User
    Join Date
    06-27-2017
    Location
    Hong Kong
    MS-Off Ver
    Office 2010
    Posts
    6

    Arranging in Descending Order & Faster Solving

    Hi Everyone!

    I have this excel file with Macro that I need help on, as I'm not an expert in it.

    OK so cells A:E are the source data, generated after pressing 'Generate Source'. The important part isn't there, but at 'Generate Combination'. Based on the Cell I2:I4, and the accuracy on I8 [currecntly at +-3(Can be seen on result column M)]

    the thing here is, it sometimes takes ALOT of time to generate the result. Apart from that, will it be possible to arrange 'sum of selection (Column O) in descending order? Instead of Ascending.

    You help will be much appreciated!

    The Password to the macro is: yusenadmin
    Attached Files Attached Files
    Last edited by iqbalsingh9; 11-15-2017 at 02:40 AM.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Arranging in Descending Order & Faster Solving

    Macros are password protected.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Registered User
    Join Date
    06-27-2017
    Location
    Hong Kong
    MS-Off Ver
    Office 2010
    Posts
    6

    Re: Arranging in Descending Order & Faster Solving

    Quote Originally Posted by kvsrinivasamurthy View Post
    Macros are password protected.
    password is yusenadmin

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Arranging in Descending Order & Faster Solving

    Data can be sorted manually after macro run.
    Sorting can be included in macro. Which is your choice.

+ 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. [SOLVED] Arranging values from Series of Arrays in Descending Order by Formula - Not Macro
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-19-2016, 06:18 AM
  2. Excel 2007 : Extract by descending order
    By Shilpa kanchan in forum Excel General
    Replies: 1
    Last Post: 12-25-2011, 03:53 AM
  3. Macro for arranging in descending order.
    By Taureankv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2010, 10:24 PM
  4. vlookup in descending order
    By thebigmancometh in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-01-2010, 09:41 AM
  5. vlookup in descending order
    By thebigmancometh in forum Excel General
    Replies: 1
    Last Post: 02-16-2010, 06:13 AM
  6. Sort in descending order
    By shahcu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2008, 03:01 AM
  7. autofill in descending order
    By suzzmenn in forum Excel General
    Replies: 1
    Last Post: 09-15-2007, 01:11 AM

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