Thread: Grouping
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Art Art is offline
external usenet poster
 
Posts: 587
Default Grouping

I have a large worksheet that I have sorted by Employee.
It looks something like this, though the actual sheet has more columns:

Company Employee
Intel Adam
Xerox Adam
Microsoft Bob
SAP Cathy
Univac Cathy
Ata Cathy
Intel Denise

I want to group by Employee, so that I see a list like this:

Adam
Bob
Cathy
Denise

I tried a Table but cannot find a way to group. I probably need an outline,
but I have not been successful in setting that up.

Thank you

--
Art