+ Reply to Thread
Results 1 to 2 of 2

Help with grouping/sorting

  1. #1
    Registered User
    Join Date
    09-21-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help with grouping/sorting

    I have a thousands of rows of data where there are 3 - 5 rows with the same record # (but ending in with different text) that I need to keep together. Each row has a different date that I need to have sorted chronologically.

    I've heard someone suggest grouping; the problem is I have so many rows and have to refresh this spreadhseet periodically making it incredibly burdensome to highlight every 3-5 rows, grouping then sorting.

    Is there any way to write a macro to automatically group every row that has a # starting with the same 3 #'s.

    Or is there another way to keep the #'s together and sort by date?

    Thanks for any help.

  2. #2
    Registered User
    Join Date
    09-22-2011
    Location
    Washington, USA
    MS-Off Ver
    Excel 2003,2007, 2010
    Posts
    85

    Re: Help with grouping/sorting

    I have an idea, but can you provide some sample data.
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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