• Go to cell F2
• Assign the formula =COUNTIF($C$2:$C$8,E2)
• Press Enter
• Drag the formula from F2 to F4

Frequently you could have to compute the number of copies in your information without the primary event. You can count the number of copies barring the primary passage similar to the past model. To count the copy models from the last model without the principal event:

• Select cell F2
• Allocate the function =COUNTIF($C$2:$C$8,E2)- 1
• Press Enter to apply the equation

Include Case-Sensitive Duplicates in Excel

The COUNTIF work in Excel is case-sensitive. You will not get the genuine count in the event that you use it to count a case-delicate copy. However, you can utilize a blend of the SUM and EXACT capacity to get a case-delicate count for copy occurrences. To track down a case-delicate count for copy values:

• Go to cell F2
• Appoint the recipe =SUM(- – EXACT($C$2:$C$8,E2))
• Press Ctrl + Shift + Enter to apply the equation as a cluster recipe.

Including Duplicate Rows in Excel

You can count copy pushes that have similar qualities in each cell. This comes in extremely helpful if you have an enormous dataset and need to distinguish copy columns for future change. The COUNTIFS work allows you to count in light of numerous circumstances. You will utilize the COUNTIFS capacity to count copy columns. In the accompanying model, you will utilize the understudy data. The information has the segments for the understudy’s names, ages, and sexual orientations. Segment E has every one of the remarkable names for which you will count the copy columns.

• Select cell F2 by tapping on it.
• Dole out the recipe =COUNTIFS($A$2:$A$8,A2,$B$2:$B$8,B2,$C$2:$C$8,C2) to F2.
• Press Enter.