find duped value <> 0 and change to 0

A

aileen

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.
 
S

Sheeloo

If your numbers are in Col A then enter this formula in B1 and copy down...

=IF(COUNTIF($A$1:A1,A1)=1,A1,0)
 
Top