Try Data-->Filter-->Autofilter
Try Data-->Subtotals
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Chad Schaben" <Chad [email protected]> wrote in message
news:[email protected]...
> I have a worksheet with 6 columns of data that look like this:
> CATEGORY AUTHOR SCENARIO
> Question1 Question2 Question3
> communication Jones multi-tasking
> marketing Anderson relationship marketing
> operations Jones Internet-based data streams
>
> I want to create a worksheet that identifies all unique authors in the 1st
> spreadsheet, tells me the number of times each author presented, and on
what
> categories.
>
> What functions will help me do this in a real-time format?
Bookmarks