+ Reply to Thread
Results 1 to 5 of 5

Automatically Ordering an Irregular Table

  1. #1
    Registered User
    Join Date
    03-17-2019
    Location
    Madrid
    MS-Off Ver
    2017
    Posts
    3

    Automatically Ordering an Irregular Table

    problem.jpg

    I want to order these sections depends on percentage values on D2 columns. The idea is "Biggest goes top". But the group of cells include pictures and irregular rows columns. How can i do that?

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    swindon, england
    MS-Off Ver
    Excel 2019 / Windows 10
    Posts
    4,204

    Re: Automatically Ordering an Irregular Table

    Try entering this formula into A3, then fill down to include the first empty row below the last section (so in the picture for 4 groups, you would fill down to A30).

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then select A3:D3 and sort by Column A values, largest to smallest.

    For aesthetic purposes, you could hide the formula in column A by using a white font.

  3. #3
    Registered User
    Join Date
    03-17-2019
    Location
    Madrid
    MS-Off Ver
    2017
    Posts
    3

    Re: Automatically Ordering an Irregular Table

    Thanks for answering but it didnt work. I have to say that when put new datas on the table right side, left side section has to be change automatically. Actually, my left side section is not a table. There is no relation between pics and values. How can i make group them? Is it more convenient to work on another sheet? If you have any idea please answer me!

  4. #4
    Forum Expert
    Join Date
    06-08-2012
    Location
    swindon, england
    MS-Off Ver
    Excel 2019 / Windows 10
    Posts
    4,204

    Re: Automatically Ordering an Irregular Table

    It worked fine for me in a quick test. There may be things in your file that cannot be seen from a picture which are causing it to behave differently for you.

    Please attach a copy of your workbook with any personal / confidential data fictionalised, or removed if it is not relevant to the question. To do this, click the 'Go Advanced' button below the quick reply window, then scroll down and look for the 'Manage Attachments' link.

    If the percentages in column D are the result of formulas, then you would need to leave the formulas and the data that they are generated from in the file. I suspect that this could be the reason why it is not working for you.

    Because you have pictures, you will not be able to sort with formulas alone, you will need a formula like the one I have already suggested to index the pictures and the rows that they relate to. You will need to sort manually or use vba.

  5. #5
    Registered User
    Join Date
    03-17-2019
    Location
    Madrid
    MS-Off Ver
    2017
    Posts
    3

    Re: Automatically Ordering an Irregular Table

    Please find attached xlsx file.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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