Count the duplicated Cell in Excel (Countif)

It's so easy to skip duplicated Cell by Excel, but it's not easy to count cell duplicated Cell. Today I'll show you, how can I count cell duplicated cell.
Count the duplicated Cell in Excel (Countif)


Today Mission
Count the duplicated Cell in Excel!

Use funtion : Countif

=COUNTIF(range, criteria)
Count the Cell the specified scope.
- Range : Specify Range Cell for this condition 
- Criteria : Number, Text of condition

Ex) =COUNTIF($E$6:$E$5605, E6)



1. At first open the list, it shows unorder List 




2. order to 'Name',





3. Make a Duplications Cells right of the 'Name' Cell




4. use function 'countif' for duplications cells
=COUNTIF($E$6:$E$5605, E6)


And it shows the duplication 'Name' cells and order List.


5. At least for decoration, I use gradation effect 'conditional formatting' and 'data bar' 



And it show duplications cells with data bar

No comments:

Post a Comment