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.
101 | 1 |
101 | 2 |
102 | 1 |
103 | 1 |
104 | 1 |
104 | 2 |
105 | 1 |
106 | 1 |
106 | 2 |
106 | 3 |
107 | 1 |