Is there an easy way to get counts of unique dates when my data set looks something like below? I will always know the days that need counted because it's by month (for instance 31 days in March: 3/1/08-3/31/08) and the Code list is constant (I've shown just 3 codes below to create a small simulation).
Sample:
Column A.....Column B
Date...........Code
03/04/2008..1
03/04/2008..1
03/07/2008..1
03/07/2008..1
03/07/2008..1
03/07/2008..1
03/21/2008..1
03/22/2008..1
03/25/2008..1
03/04/2008..2
03/06/2008..2
03/06/2008..2
03/31/2008..2
03/04/2008..3
03/22/2008..3
03/24/2008..3
03/31/2008..3
and so on
So what I need summarized for me is the # of unique days per code:
Code....Unique Days
1.........5
2.........3
3.........4
I don't think a Pivot table can accomplish this, or can it? I would think this would be easy, but I'm drawing a complete blank and have no ideas so any help would be greatly appreciated.
Bookmarks