• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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