How to show a count of Unique IDs in a Pivot Table

[Dave K]

Is there a way to use Pivot tables in a way that shows a count of
Unique IDs (over time).

The problem I am having in using the Pivot table to show trended data,
is that the "Count" option produces a count of each record that has
any information, when oftentimes I simply need a count of unique IDs.

So the below Column would have a count of 3 Names, when I prefer for
it to produce a count of 1 Name. Any recommendations would be
appreciated.....

Name

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Count Unique IDs
http://www.mediafire.com/file/dgmmaznjyy2/06_21_09.xlsx

 

[Dave K]

Thanks very much Herbert. So it looks like i am out of luck if i don't
have 2007....