+ Reply to Thread
Results 1 to 4 of 4

how to sort grouped data in excel 2003?

Hybrid View

  1. 10-17-2013, 07:58 PM #1
    newdoverman
    newdoverman is offline
    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
    Reply With QuoteRegister To Reply
  2. 10-17-2013, 08:08 PM #2
    FDibbins
    FDibbins is offline
    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
    53,048

    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
    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1