find duped value < 0 and change to 0
I have a column of data as such:
0
0
360
360
360
0
0
0
-1468
-1468
-1468
0
0
0
I would like to change any values that are duped to 0 except for the first
different value found. The column of data above should become as below:
0
0
360
0
0
0
0
0
-1468
0
0
0
0
0
Is this possible? Thanks for any help.
|