create list of unique values from a column with repeated values?

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 Schaben@discussions.microsoft.com> wrote in message
news:8A88B184-ECC3-4DEF-B411-B89AFC13E607@microsoft.com...
> 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?

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 Schaben@discussions.microsoft.com> wrote in message
news:8A88B184-ECC3-4DEF-B411-B89AFC13E607@microsoft.com...
> 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?

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?

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 Schaben@discussions.microsoft.com> wrote in message
news:8A88B184-ECC3-4DEF-B411-B89AFC13E607@microsoft.com...
> 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?