How to count the number of repetitions in a row in excel?

Statistical repetition times can be realized by countif function.

As shown in the figure, the formula of L2 cell is =COUNTIF($K$2:K2, K2). This formula means counting the number of times K2 appears in the $K$2:K2 region. Because this area uses different reference methods, it becomes a spring-type reference area. If you copy the formula downward, the area of the formula will increase, thus realizing the function of counting the number of occurrences.