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.

find duped value < 0 and change to 0
 

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)

"aileen" wrote:

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.

find duped value < 0 and change to 0
 

Worked perfectly. Thanks

"Sheeloo" wrote:

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)

"aileen" wrote:

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.