| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
create list of unique values from a column with repeated values?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
| How do you create a list with name address phone in a column form. | Excel Discussion (Misc queries) | |||
| How can I create a list that skips zero values? | Excel Worksheet Functions | |||
| Finding Unique Values in Column | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Hybrid Mode
