Jason, Thanks for the quick response. I did what you suggested. Using a
simple example:

Name Amount
Cindy 1
Cindy 2
Ann 3
Jordan 4
Jordan 5

The results in the row show;

Ann
Cindy
Jordan

Which is correct, it is only showing three items. Obvious to see in this
example but I have hundreds of rows and need a count of unique items. If I
put the name in the data area of the pivot table and ask for a count I will
get 2 for Cindy 1 for Ann and 2 for Jordan, showing the total number of times
I have a name listed not the unique value.

Thanks again for your help.


"Jason" wrote:

Yes:

1) Ensure your source data is tabulated correctly:
- Contigous range with no blank rows/columns
- column headings etc.
2) Insert Pivot table
3) Place the field you want to count unique in the 'ROW'
section of the pivot table

The resulting display will be a unique list of items from that
particular column, so the number of items in the list *is* your unique
count.

Jay
--



Jordan wrote:
Is these a way to use a pivot table to count unique items in a set of data?

Thanks for you help.