Get instant live expert help on I need help with excel distinct count

“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

Get the count of distinct players played across years
Solved by Z. J. in 13 mins
Distinct count, unique values in pivot tables
Solved by G. U. in 19 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 excel count distinct in the field value settings. Can you help?
Solved by S. Q. in 22 mins
I need pivot table help, how to insert pivot table in excel, insert a calculated field, using distinct counts
Solved by B. B. in 26 mins
For each material if there is more than one distinct value in the status column then it should appear as true otherwise false, then i need to to pull all the true values into a second excel tab
Solved by A. D. in 21 mins