AutoFiltering with Grouped Data

D

Dan

Is it possible to maintain cells grouped togther (using the Data->Group and
Outline->Group) when using Autofilter?

Here is what I have

C1 C2 C3 C4 C5 C6 .... C15
R1 apple 2 3
R2 ab ac gd .... r5
R3 ee et tg .... cb
R4 cf de ij .... ok
R5 pear 4 5
R6 ab ac gd .... r5
R7 ee et tg .... cb
R8 tree 3 6
R9 0d 34 4f .... gi

Now rows 2-4 are grouped, 6&7 and 9 so that they collapse under their header
in columns C1-C3. There is also a filter set up on C1, C2, C5 and C6. (Used
Autofilter, then hid the display of the arrors on C3 and C4). Each
entry in column C1 may have multiple entries with different data in C4 - C15.

Now when I use the autofilter to select "pear" I want to maintain the
grouping underneath to see the different information that has been entered.

Any ideas?
 
D

Dave Peterson

I would drop the data|Group stuff and just use data|autofilter.

But I would have to fill up those empty cells in those columns (A:C??) with the
values directly above.

If you don't like the duplicated look, you could hide the duplicates using
format|conditional formatting.

But I wouldn't. If I filtered to show only the 2nd line, of that "group" (maybe
filtering on column J), then I wouldn't be able to tell what's in column A:C.

If you want to try, see Debra Dalgleish's site:
http://www.contextures.com/xlDataEntry02.html
http://www.contextures.com/xlCondFormat03.html#Duplicate
 
D

Dan

Thanks I will try filling the values below the columns to see if it would work.

Since the information is excessinve dropping the data|Group would make
viewing the header information difficult. The Group setting was to hide the
details of the data unless someone wanted to see it.

Thanks for the suggestion.
 
D

Dave Peterson

Instead of using data|filter|Autofilter or Data|Group, maybe sorting the data
and using data|Subtotals would be better????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top