Get instant live expert help on I need help with group 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

Hi, I have a table that shows a list of groups (group a, group b etc) and displays that there are 2 people in group 'a', 5 people in group 'b', 2 people in group 'c', 6 people in group 'd' etc... I would like to format/display the list show so it only shows the groups that have 2 or less people in each group... I am a complete excel novice.... Thanks you!
Solved by T. Q. in 26 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
compare and Highlight Duplicates in side by side columns of Excel
Solved by C. A. in 30 mins
I want the formula in column AK to be edited in order to remove the duplicates in each group. For example AK43 is a duplicate. There should be no more entries until a new trade is opened (an entry in column x, or column w changes)
Solved by T. S. in 12 mins
Hi, I am just trying to group dates in my Excel pivot by weeks not days and it won't let me group them.
Solved by O. A. in 15 mins