+ Reply to Thread
Results 1 to 3 of 3

Sort & Subsort

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Sort & Subsort

    I am having a real tough time trying to figure out how to get my data sorted the way I want. Need a little help.

    Essentialy on the spreadsheet attached, I have a series of work packages that have a baseline, forecast and actual date assocaited with them. The dates span over 13 seperate activites.

    I want to sort based on Column K (Date 1), earliest first, while keeping the forecast and actual dates below it that belong to that package group. So which package has the earliest Baseline date will be listed first then its Forecast then its Actual, next earliest Baseline with its forecast and actual.

    I have tried advanced sorting, but it jumbles the packages around.
    Attached Files Attached Files

  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: Sort & Subsort

    In col X:

    X
    Y
    2
    12/09/13
    X2: =K2
    3
    12/09/13
    X3: =K2
    4
    12/09/13
    X4: =K2
    5
    11/05/13
    X5: =K5
    6
    11/05/13
    X6: =K5
    7
    11/05/13
    X7: =K5


    Enter the first three formulas, then select ALL THREE CELLS and drag down.

    Sort by that column.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Sort & Subsort

    I ended up doing something similar by essentially building a serial number for each column using the rank.eq formula. Thank you for the assistance.

+ 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] I have a sort macro. How to add script to preselect rows to sort based on column value?
    By Jasonhouse in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-09-2014, 02:25 AM
  2. Replies: 2
    Last Post: 01-15-2014, 09:31 AM
  3. Replies: 4
    Last Post: 11-20-2012, 06:00 PM
  4. How to Subsort?
    By tynan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-15-2008, 07:50 AM
  5. [SOLVED] Pls. reply Sort Data and copy to next coulmn when sort order chang
    By shital shah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2005, 10:05 AM

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