Dublicates counter

Highlighted
Occasional Visitor

Hello all, 

 

So what I am trying to build is a formular which generates for every number the value 1 except the number appears more than one time. 

If the Number appears more than one time the system should count the dublicates until a new number appears. 

Please find the table below. 

 

1011
1012
1021
1031
1041
1042
1051
1061
1062
1063
1071

 

 

 

1 Reply
Highlighted

@ATSV1900 

Assuming your numbers are in column A starting from A1, put in B1

=COUNTIF($A$1:$A1,A1)

and drag it down