Get instant live expert help on how to count distinct values in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a problem regarding to How to Count Unique and Distinct Values in Excel
Solved by S. J. in 20 mins
Distinct count, unique values in pivot tables
Solved by G. U. in 19 mins
hi there is no count distinct at my excel
Solved by K. E. in 29 mins
Get the count of distinct players played across years
Solved by Z. J. in 13 mins
I have a pivot table of Server names that are duplicated down a list of database /table names. Total count is >500 but I want to show the distinct count in the pivot, which is closer to 90. I'm in 2010. I've tried inserting a formula =counta(), but it isn't working and 2010 does not have Distinct Count in the field value settings. Can you help?
Solved by S. Q. in 22 mins