count and numbering

For the whole column please try and copy down:

Formula:

=COUNT(MATCH(B$4:B4,C$4:C$15,0))

For only the end result please try:

Formula:

=COUNT(MATCH(B4:B15,C4:C15,0))