Get instant live expert help on count duplicates 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 need your help in finding out the duplicates from the column A and the total number(count) of duplicates should come in the column B. The only condition is count should come only once. see the attache sheet.
Solved by X. W. in 23 mins
how do I remove duplicates without losing the line count?
Solved by M. A. in 12 mins
using a pivot table I am looking to count all the unique fixtures in my excel sheet. At the moment it is counting all fixtures, do you know how to remove duplicates?
Solved by E. H. in 23 mins
On Sheet 1, Column C I am trying to use a Count formula to count the number of transactions that fall within certain parameters. All this data has been dumped into Sheet 2. My problem is that my count is counting duplicates. I'd like to keep the fomula I have in column C of Sheet1 but add something else that will allow for not counting duplicates in column J of sheet2
Solved by A. J. in 20 mins
I have two columns in Excel when I select remove duplicates it says no duplicates but there are approx. 3100
Solved by M. H. in 15 mins