Pivot table help

[KevinThomas]

Hi, I have a data set with numerous repeat entries.

I want to know how to count how many unique entires there are (I assumed Pivot table would be the best shot), but all I can find on pivot table will count the TOTAL amount,m not the unique items.

say for instance I had

bag
brush
brush
comb
bag
gel

etc ... in a column, how do i count 4 - as in 4 different items regardless of how many times they appear?

Thanks in advance

[martindwilson]

one way is this array formula confirmed wit ctrl+shift+enter
=SUM(IF(FREQUENCY(MATCH(A1:A10,A1:A10,0),MATCH(A1:A10,A1:A10,0))>0,1))
or maybe better still array entered
=SUM(1/COUNTIF(A1:A10,A1:A10)

[mubeenff]

make a pivot table and in colmn c enter 1 and drag down u will get the count(see attached file)