How to Count Duplicates in Microsoft Excel | Group and Count Duplicates

In this video I demonstrate how to count how many times a given value is duplicated.
Table of Contents:
00:00 - Introduction
00:28 - Remove Duplicates Method
03:41 - UNIQUE Function Method
------------------------

[@IvanCortinas_ES]

Excellent explanation Chester. Thank you!!!

[@kashifali8002]

This was very helpful, thank you for sharing!

[@user-mu8vg8zq3g]

thank you !Exactly what I needed

[@markfranciscarmelotes6758]

Thank you!

[@vasobg12]

Hell yea. This will save me a tone of work. Thanks ❤

[@Study-Always]

THANK YOU!

[@beverleymason8149]

THANKS- really clear and helpful!

[@416nighthawk]

Excellent video. This is exactly what I was searching for. Question though: how do you NOT count the hidden duplicates?

[@vickyrodriguez4779]

Awesome 👍👍👍👍👍

[@ChesterTugwell]

Thanks 🤗

[@geedoctor]

How do you 'copy this down'?

[@waleedibrahim4558]

Hi Chester, Thank you for your informative videos. I have a particular case in excel in which I couldn’t find any solution to it and I hope you can help me with it. If I have various numbers in column B, and I need these numbers to be (increased/decreased):
- By 0.5 either to make it 20.5 or 19.5
- Or by 1 to make it either 21 or 19
- Or 2 to make it 22 or 18 …etc.
The change should be based on two conditions, a selected text from a drop-down list in the next cell in column C in addition to a number I type in the cell next to them in column D, for example:
- The first case scenario is: When I type the number 20 in cell B2 and then I choose the text “increase” from a drop-down list in cell C2 and then I type 0.5 in the cell D2, I want this “increase” to be reflected on B2 and make it 20.5
- The second case scenario: When I type the number 15 in cell B3 and then I choose the text “decrease” from a drop-down list in cell C3 and then I type any number like 1, 2 or 3 in the cell D3, I want this “decrease” to be reflected on B3 and make it 14, 13 0r 12
- The third case scenario: When I type number 10 in cell B4 and then I don’t choose any text from a drop-down list in cell C4 and leave it blank with cell D4, I don’t want any change to be reflected on B4 and leave it 10 as it is.
I hope you can find time to answer this very soon. Thanks again.

[@txreal2]

Count duplicate in a table? Thanks.

[@Blackronin357]

For my needs, I need to count how many times a value appears. There are only two unique values in this column range.