+ Reply to Thread
Results 1 to 5 of 5

Sort whilst keeping the rows in sub order.

  1. 04-26-2015, 05:35 PM #1
    markDuffy
    markDuffy is offline
    Forum Contributor
    Join Date
    03-25-2011
    Location
    London, England
    MS-Off Ver
    office 2021
    Posts
    317

    Sort whilst keeping the rows in sub order.

    Hi Guys
    Sort whilst keeping the rows in sub order.
    I have a set of numbers which have the same column headings but are in different row groups. The row groups have percentages applicable Column F to each row and these are added up to give a total Column I. What I am looking for is to sort out the total for the groups using column I into descending order but keeping all the rows in each group in their original order.
    I am sorry the title is so obscure. I have no idea how to make it short and simple. I have up loaded a file which makes it more straight forward. I have no idea how to start this.

    Again thanks in advance.

    Mark
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-26-2015, 06:23 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Sort whilst keeping the rows in sub order.

    Try this approach.

    1. Put this in I2 and copy down...
    =SUMIF($A$2:$A$65,A2,$F$2:$F$65)
    2. Sort on I and then A (or your preference)

    If you want to hide all-but-1 of the totals, you can add another column and use this, copied down...
    =IF(I2=I3,"",I2)
    then hide column I
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 04-27-2015, 02:36 AM #3
    markDuffy
    markDuffy is offline
    Forum Contributor
    Join Date
    03-25-2011
    Location
    London, England
    MS-Off Ver
    office 2021
    Posts
    317

    Re: Sort whilst keeping the rows in sub order.

    Hi Thanks
    i see how you are sorting this out. I need to reorganize my underlining to distinguish the stocks.
    I will also try it when there are many more stocks up to 150. So use last row.
    But thanks
    Mark
    Reply With QuoteRegister To Reply
  4. 04-27-2015, 02:45 AM #4
    markDuffy
    markDuffy is offline
    Forum Contributor
    Join Date
    03-25-2011
    Location
    London, England
    MS-Off Ver
    office 2021
    Posts
    317

    Re: Sort whilst keeping the rows in sub order.

    Hi FDibbins
    I have popped it into a bigger sheet and i will need to make it so that it can keep working till it has covered all the rows and not just till a specific number. But thanks for solving the approach.
    Mark
    Reply With QuoteRegister To Reply
  5. 04-27-2015, 10:59 AM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Sort whilst keeping the rows in sub order.

    I just used that range because that what you gave me. You could change that to...
    =SUMIF($A:$A,A2,$F:$F)

    Glad it worked for you, and thanks for the feedback
    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)

Similar Threads

  1. Sorting rows into numerical order while keeping gaps
    By motorcycle in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 12-22-2014, 05:41 PM
  2. Taking data from columns and rows to create only rows whilst keeping multiple ID reference
    By RufusParker in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-05-2014, 05:34 AM
  3. Edit Macro Code to Accomodate 300+ Rows (Pulling Many Rows Over and Keeping in Order)
    By CHRISOK in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-24-2013, 01:31 PM
  4. Inserting rows whilst keeping filter range.
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2010, 09:44 AM
  5. Automatically keeping rows sorted in alphabetical order
    By damiensmith212 in forum Excel General
    Replies: 8
    Last Post: 04-24-2009, 06:50 PM

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