+ Reply to Thread
Results 1 to 4 of 4

how to sort grouped data in excel 2003?

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    mexico
    MS-Off Ver
    Excel 2003
    Posts
    3

    how to sort grouped data in excel 2003?

    I give you guys an example

    Project Priority Viability Other Data
    Project 1 3 1 Architect landa
    Constructor Demeyer
    Developer Koolhaas
    Project 2 1 3 Architect Demeyer
    Constructor Renzo
    Developer Alvar Aalto
    Project 3 2 1 Architect FLW
    Constructor landa
    Developer Nemeyer
    Project 4 2 2 Architect Mies
    Constructor Lecorbusier
    Developer Renzo



    I want to get it like this

    Project Priority Viability Other Data
    Project 1 3 1 Architect landa
    Constructor Demeyer
    Developer Koolhaas
    Project 3 2 1 Architect FLW
    Constructor Landa
    Developer Nemeyer
    Project 4 2 2 Architect Mies
    Constructor Lecorbusier
    Developer Renzo
    Project 2 1 3 Architect Demeyer
    Constructor Renzo
    Developer Alvar Aalto


    An then the same but in order of priority? it's possible without using macros or any other complex solution? of course this projects are grouped and I want to keep them...

    Thanks!

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: how to sort grouped data in excel 2003?

    I think that you would be better off if your data was arrange like this:

    A
    B
    C
    D
    E
    1
    Project
    Priority
    Viability
    Other Data
    2
    Project 1
    3
    1
    Architect landa
    3
    Project 1
    3
    1
    Constructor Demeyer
    4
    Project 1
    3
    1
    Developer Koolhaas
    5
    Project 2
    1
    3
    Architect Demeyer
    6
    Project 2
    1
    3
    Constructor Renzo
    7
    Project 2
    1
    3
    Developer Alvar Aalto
    8
    Project 3
    2
    1
    Architect FLW
    9
    Project 3
    2
    1
    Constructor landa
    10
    Project 3
    2
    1
    Developer Nemeyer
    11
    Project 4
    2
    2
    Architect Mies
    12
    Project 4
    2
    2
    Constructor Lecorbusier
    13
    Project 4
    2
    2
    Developer Renzo


    Now, you can use the FILTER to sort the way that you want.
    A better arrangement is this:

    A
    B
    C
    D
    E
    F
    1
    Project
    Priority
    Viability
    Architect
    Constructor
    Developer
    2
    Project 1
    3
    1
    landa Demeyer Koolhaas
    3
    Project 2
    1
    2
    Demeyer Renzo Alvar Aalto
    4
    Project 3
    2
    1
    FLW landa Nemeyer
    5
    Project 4
    2
    2
    Mies Lecorbusier Renzo
    Last edited by newdoverman; 10-17-2013 at 08:07 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: how to sort grouped data in excel 2003?

    If you cannot get your data in the format suggested by newdoverman, you could try this alternative using a helper column.

    Assuming your data is in A1:E14 (with row 2 empty), I put this in F3, copied down
    =IF(A3="",F2,A3)

    You can copy/paste values to give you just teh values, and then sort om F and which ever other column/s you want
    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

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: how to sort grouped data in excel 2003?

    Another option, which would fill in the blanks for you, is this method put together by Pete_UK...
    http://www.excelforum.com/excel-gene...el-2003-a.html

+ 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. How to sort Grouped data in Excel
    By bool in forum Excel General
    Replies: 20
    Last Post: 09-08-2016, 08:24 PM
  2. Sort Grouped data in Excel
    By justjazziness in forum Excel General
    Replies: 0
    Last Post: 09-28-2012, 12:22 PM
  3. How to sort Grouped data in Excel
    By lly in forum Excel General
    Replies: 1
    Last Post: 08-10-2012, 08:31 PM
  4. How do you sort Grouped Data in 2003?
    By Noshiza in forum Excel General
    Replies: 9
    Last Post: 01-26-2012, 06:47 PM
  5. Format and Sort Grouped Data in Excel
    By loguie668 in forum Excel General
    Replies: 1
    Last Post: 03-23-2011, 08:44 PM

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