• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

Excel - Group, Auto-Outline Quirk or Error? How come it misses a group of data

In the attached worksheet and graphic, I ran Group/Auto-Outline and the application did not capture and group the female dogs, only the male dogs at the bottom of the body of data.
Why is this?  
How can I have auto-outline capture both genders?
errgrouping-animals.xlsx
0
brothertruffle880
Asked:
brothertruffle880
1 Solution
 
Elton PascuaCommented:
Is this how you want it to look like? If it is, here's how I did it.

1. Group Females
2. Group Males
3. Group both Males and Females
grouping-animals2.xlsx
0
 
DIIRECommented:
It seems as that excel will join them if you try to create 2 separate groups in the same section.

I added a subtotal for Males and Females and then I could get the 2 groups to display separately.  Not sure if this is what you are after.  But I couldn't find any other to get it to separate them.
Copy-of-grouping-animals.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now