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.