What is a macro for counting repetitions in Excel?

Question

Macros

Hello. There is such a table


What formula is required for such a task:

First column
product_id (ours)
Duplicate ID go

Last column
hotline sort parameter
Number in the list. In a specific ID range.

It was:
55332 2
55332 2
50696 2
50696 2
50696 2
55332 2
55332 2
55332 2


It became
55332 1
55332 2
50696 1
50696 2 50696
3
55332 1
55332 2
53 Thank you.

Answer 1

=COUNTIF($A$2:A2,A2)
Insert into the desired column in the second row and drag down