+ Reply to Thread
Results 1 to 3 of 3

Sorting by grouped category

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    2

    Sorting by grouped category

    Excel Wizards,

    I am trying to figure out how to organize a large spreadsheet as efficiently as possible.

    Basically, I have a worksheet with URLs to my own articles, and potential forums where I might be able to share my expertise. I want to be able to sort the worksheet by the Topic, and have the corresponding information sort along with the topic. I also want to be able to group the information for each category (see attached), or by some other method collapse the data so the I can simply browse through the topics without the rest of the congestion. I have attached a worksheet with a basic skeleton of what I was thinking.

    Overall, I want a condensed/collapsible spreadsheet that will sort by topic and bring corresponding information along with it.

    Bonus: If I could sort by the largest # of articles or largest # of related forums that would be swell!

    I tried sorting and using pivot tables, but then I ended up with blanks or unnecessary information. When I collapse the groups, I can't sort by just the topics without all of the data shifting around. If anyone has any suggestions as to how I can make sense of the spreadsheet it would be much appreciated! I know this might be confusing so please respond with any questions.

    Cheers,
    Tony
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Sorting by grouped category

    Hi Tony,

    Instead of using Groups, I think you would be better off using AutoFilters. That way you can filter by any of your columns and sort by any of them also.

    http://www.excelfunctions.net/ExcelFilter.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    07-09-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Sorting by grouped category

    Thanks Marvin.

    I think that's what I will do. I was hoping that it could somehow be collapsible, but I guess I'd be sacrificing functionality for convenience.

    I appreciate the help!

    Cheers,
    Tony

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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