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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create table of unique values? 2
How to create a multi column lookup list? 3
FINDING AND LISTING UNIQUE DATA IN A COLUMN 3
how to sum all values of a variable that's repeated multiple times 2
list unique values in a column 1
Create unique list of names from list of duplicates and that arefound within another range 1
Formula (not adv. filter) to list unique values from list 6
Count unique values and create list based on these values 7

Back
Top