JENESIS9777
New Member
- Joined
- May 19, 2010
- Messages
- 14
Hello,
I need a pivot table to sort how many unique names were entered in Column E per Month (month is Column C). How do I do this I can count unique names? I have only had total number of occurences.
For Example
Column C= Month (litterally the month name not a whole date) or should I use a date range instead? I have actual dates in column B.
Column E= Names
I entered 10 Names In June
I entered ? Names in May, etc.
But I need how many unique names, because many of the names repeat over the months.
Thanks using excel 2003.
I need a pivot table to sort how many unique names were entered in Column E per Month (month is Column C). How do I do this I can count unique names? I have only had total number of occurences.
For Example
Column C= Month (litterally the month name not a whole date) or should I use a date range instead? I have actual dates in column B.
Column E= Names
I entered 10 Names In June
I entered ? Names in May, etc.
But I need how many unique names, because many of the names repeat over the months.
Thanks using excel 2003.