pivot table

[maacmaac]

I need to count the number of unique numbers in a single column. I am using a pivot table but receiving an error message that my field of source data has more unique items that can be used in a Pivot Table. I there another way to count unique items?

Thanks in advance for any comments.

[starguy]

I need to count the number of unique numbers in a single column. I am using a pivot table but receiving an error message that my field of source data has more unique items that can be used in a Pivot Table. I there another way to count unique items?

Thanks in advance for any comments.

check these links

http://www.mrexcel.com/archive/Formulas/17137a.html

http://office.microsoft.com/en-us/ex...448621033.aspx

[maacmaac]

I tried using the formula given from Mr. excel, but it did not work. Any other suggestions?