View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aileen aileen is offline
external usenet poster
 
Posts: 78
Default 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.