Get instant live expert help on I need help with excel count duplicate values only once

“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 need a formula to count a column item in which it count once a quantity. if there are so many duplicate vale of a quantity then it count it only once.
Solved by B. Y. in 13 mins
I have a problem regarding to How to Count Duplicate Values in Excel
Solved by I. E. in 17 mins
I am searching for a formula to identify a unique value iso removing the duplicate The result of this formula I use in a pivot table to count only each number once
Solved by B. E. in 24 mins
I have 2 cells containing a % value. The value for both is 9%. I want to conditionally format these cells as duplicate values but excel only highlights them as duplicate values if the decimal point is exactly the same. How can i correct this?
Solved by S. C. in 11 mins
I am comparing two spreadsheet. what do I do after format only unique /duplicate values?
Solved by D. W. in 21 mins