+ Reply to Thread
Results 1 to 3 of 3

Filter or Sort Grouped rows

  1. #1
    Registered User
    Join Date
    10-09-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    49

    Filter or Sort Grouped rows

    Hi!

    Ok so not sure how to clearly explain this.

    Looking to be able to filter or sort or both a report by account. I have the rows grouped as columns B/C/D/E/F/G is just account info but ROWS 7-12 have all the data which starts in Col H and onward. My issue is that when I go to select one ACCT # and then ungroup it shows the data rows of the other accounts. I just want it to show that account.

    I tried to merge the rows in column B/C/D/E/F but it's not working either.

    I want to option to see overall at acct level, un-groupped to show division data or by specific account.

    Hope my screen shots will help.

    Thx
    Attached Images Attached Images
    Last edited by Rellsunn; 08-24-2017 at 07:34 PM.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Filter or Sort Grouped rows

    Hi Rellsunn,

    One solution is to copy in the grey cells the information for the account (yellow cells)
    You can change font color to grey if you want.

    Then you'll be able to sort and filter without any problems.

    GC
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Filter or Sort Grouped rows

    First unfilter the data and Select the whole date means A1 to till the last column and last row, now make again filter tabs. Try to filter see may be it would work.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ 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. Sort Grouped Rows &/or Columns
    By mycon73 in forum Excel General
    Replies: 3
    Last Post: 02-27-2017, 01:06 AM
  2. [SOLVED] Is there a way of using the Filter Function when Rows are grouped
    By Jamidd1 in forum Excel General
    Replies: 2
    Last Post: 11-15-2016, 09:08 AM
  3. Sort Grouped Rows
    By Unifyzero in forum Excel General
    Replies: 2
    Last Post: 05-23-2013, 05:45 PM
  4. keep rows grouped and sort
    By johnny1 in forum Excel General
    Replies: 4
    Last Post: 07-22-2010, 02:03 PM
  5. Data Filter on grouped rows
    By mystic342005 in forum Excel General
    Replies: 0
    Last Post: 07-29-2007, 12:04 AM
  6. How to sort when info is grouped in rows?
    By LaVerne in forum Excel General
    Replies: 5
    Last Post: 06-20-2005, 08:05 PM
  7. How to sort by grouped rows
    By Mike in forum Excel General
    Replies: 2
    Last Post: 04-05-2005, 06:06 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