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.
Assuming your numbers are in column A starting from A1, put in B1
and drag it down