how to count repetitive values from Excel

We cannot work from images, please attach your workbook, or an accurate example of it.

As an example, check below steps

Often you might need to calculate the number of duplicates in your data without the first occurrence. You can count the number of duplicates excluding the first entry in the same way as the previous example. To count the duplicate examples from the last example without the first occurrence:

Select cell F2.

Assign the formula =COUNTIF($C$2:$C$8,E2)-1.

Press Enter to apply the formula.

This will help you,
J Walter