+ Reply to Thread
Results 1 to 5 of 5

Need to sort groups of data and maintain rows.

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    Oregon City, Oregon
    MS-Off Ver
    Excel 2013
    Posts
    4

    Need to sort groups of data and maintain rows.

    Ok here is what i need to to:

    I need to sort groups of data by a single cell in the group, compared to other single cells in other groups of data. The groups are always the same number of rows but vary in the number of rows. There is an example file below. The red is the company name and the green is what I need to sort the group by, as compared to the other groups. This example only has a few, the real file has thousands of groups. I want to sort the companies by the totals in green...they are currently in alphabetical order. There must be a way to do this without going the VBA option.
    Example 1.xlsx

    Please Help!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,240

    Re: Need to sort groups of data and maintain rows.

    Hi and welcome to the forum

    sorry, confused....
    The groups are always the same number of rows but vary in the number of rows
    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

  3. #3
    Registered User
    Join Date
    01-03-2014
    Location
    Oregon City, Oregon
    MS-Off Ver
    Excel 2013
    Posts
    4
    Sorry! I meant the columns stay the same and the rows will vary in ninber . see the example.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,240

    Re: Need to sort groups of data and maintain rows.

    OK, that makes sense now LOL.

    I started off by adding a helper column (AA) and copied this down...
    =IF(G7="",AA6,G7)

    But the problem comes in when you try to sort, that you have merged cells withing the range, and sorting doesnt play nice with merged cells

  5. #5
    Registered User
    Join Date
    01-03-2014
    Location
    Oregon City, Oregon
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Need to sort groups of data and maintain rows.

    Any additional help with this would be great. thanks

+ 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. Maintain data on one sheet and sort on another
    By fiat124cc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2013, 07:05 PM
  2. Replies: 8
    Last Post: 08-15-2012, 02:42 AM
  3. [SOLVED] Macro to sort data in spreadsheet but maintain empty rows between data.
    By vzc8 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-12-2012, 12:31 AM
  4. Sort Groups of Rows
    By slide in forum Excel General
    Replies: 2
    Last Post: 04-02-2008, 04:58 PM
  5. [SOLVED] How can I sort in groups of 3 rows?
    By Blue in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2005, 06:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1