Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
grouping Pammy Excel Discussion (Misc queries) 1 March 29th 07 06:22 AM
Grouping Geoffrey Allen Excel Worksheet Functions 1 January 16th 07 12:47 AM
Grouping Rachana Excel Worksheet Functions 1 October 7th 05 10:19 PM
Grouping Kevin M Excel Worksheet Functions 1 June 10th 05 11:11 PM
Grouping Ray Excel Discussion (Misc queries) 0 March 2nd 05 04:51 PM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"