# Counting The Repetitive Occurrence Value

Sep 3, 2008i want the formula to be used in excel to make acounter in another column for the values the occured repetitively

like to have these two column.

ex:

Oper No

Work Center

10 Paintsh

20 Paintsh

30 Paintsh

40 Paintsh

50 Paintsh

60

Paintsh

70 Paintsh

80 Paintsh

90 Paintsh

here the operation no is the counter for the repeated work center whose name is paint sh