Hello,
I have exported values from a defect tracking system into excel
Each defect is categorized in one of a couple of hundred different
categories.
I want to somehow display the count of the unique categories (and not the
number of defects asssociated with each category).

Is there a way to do this using Pivot table functions -- as opposed to
exporting the list, using advanced filters, etc.

Thanks in advance

BAM