Hi All,
First thank to all who contribute, I've found this forum to be immensely helpful. I've searched through the forums but haven't quite found a solution to my issue. I have a set of values in Col A which have a related date in Col B. What I would like to do is count unique values in A where date is in year 2013 (or other variations such as between 1/1/2013-3/31/2013). Secondly, I would like to be able to visualize by month the unique counts of A. For instance, Unique Names down vertical and Months for each year along the vertical access. Could be table, chart, pivot.

I'm attaching a sample sheet if the above doesn't quite make sense.unique values by month.xlsx

Many thanks!
Kerry