+ Reply to Thread
Results 1 to 2 of 2

Sorting data in groups

  1. #1
    Registered User
    Join Date
    03-30-2010
    Location
    midwest usa
    MS-Off Ver
    Excel 2003
    Posts
    1

    Sorting data in groups

    I have multiple projects and each project has data on 3 consecutive rows. Between each project's set of 3 rows is a blank row sepearation them. The projects are in no specific order and need to be placed in order. In one column I have a project number (on all 3 rows for each project) that can be used to sort.

    How can I sort these and keep a blank row between each set of 3 rows for a particular project?

    I have thought about doing it as follows but hope there is a better way:
    have a macro perform a sort on the project number for the entire data set then have the macro go through and add a blank row at each change in project number.

    If this is the best way to handle this, I will need some generic help on the verbage of the code to pull off the insertion of blank rows at each change in project number.

    Thanks.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Sorting data in groups

    If the project numbers are just whole numbers, and start in A2. In F2 (or any unused column),

    =IF(A2="", SUM(F1, 0.1), A2)

    Then sort by that column.
    Entia non sunt multiplicanda sine necessitate

+ 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