+ Reply to Thread
Results 1 to 6 of 6

Sorting grouped rows ?

  1. #1
    Registered User
    Join Date
    04-07-2014
    Location
    Owings Mills, MD
    MS-Off Ver
    Excel 2010
    Posts
    4

    Sorting grouped rows ?

    I'm pretty sure this will be a programming question. I have searched and searched and have seen other similar questions but the answers are not working for my particular situation.

    I have data grouped by the specific client. claims vs premiums reports that include total cardholders, breakdown by tier etc.

    I need to be able to sort these reports by total cardholder and still keep the data per client together.

    See attached report. This is all sample data and the actual report I am working with is about 10,000 rows.

    Any help is greatly appreciated!!

    Karie
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Sorting grouped rows ?

    Hello Kariej1004,

    Welcome to the Forum!

    There is no example of what the sorted data should look like. Can you provide one?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    04-07-2014
    Location
    Owings Mills, MD
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Sorting grouped rows ?

    Quote Originally Posted by Leith Ross View Post
    Hello Kariej1004,

    Welcome to the Forum!

    There is no example of what the sorted data should look like. Can you provide one?

    Thank you for the quick response Leith, column C is my cardholders per client. So the total cardholders for the first client is row 8. I need to be able to pull out all groups with cardholders totaling between 1 and 5, between 6 and 25 , 26 and 50 etc. I need to keep them together because once they are separated by cardholder, I need to process the total loss ratio (Column T Row 8) for each cardholder (1 -5, 6-25 etc) group.

  4. #4
    Registered User
    Join Date
    04-07-2014
    Location
    Owings Mills, MD
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Sorting grouped rows ?

    Sorry I didnt answer your question well. The sorted data needs to look exactly like it looks now, only sorted by total cardholder per group.

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Sorting grouped rows ?

    Hello Kariej1004,

    The explanation is helpful but I was hoping for a visual example. Nothing large, perhaps 2 or 3 sorted groups. Another question I have is will the results be placed on another sheet?

  6. #6
    Registered User
    Join Date
    04-07-2014
    Location
    Owings Mills, MD
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Sorting grouped rows ?

    Ok, I just went through and did the originally test group by hand. See the tabs at the bottom are representing total cardholders (1-5,6-25 etc) So I moved each group to its specific sheet based on the total number of cardholders.
    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)

Similar Threads

  1. [SOLVED] Keep grouped rows together while sorting by a value in a cell
    By cbrandonsmith in forum Excel General
    Replies: 2
    Last Post: 04-06-2014, 06:45 PM
  2. Replies: 2
    Last Post: 01-10-2014, 09:30 PM
  3. Sorting grouped data
    By dmendes11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2013, 06:21 AM
  4. [SOLVED] Sorting Grouped Rows and Formatted Cells
    By sonny.thind in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-29-2012, 01:47 PM
  5. [SOLVED] Sorting with multiple rows grouped
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2006, 09:50 AM

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