Forum Discussion
Dublicates counter
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 sy...
Assuming your numbers are in column A starting from A1, put in B1
=COUNTIF($A$1:$A1,A1)and drag it down