find duped value <> 0 and change to 0

  • Thread starter Thread starter aileen
  • Start date Start date
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.
 
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)
 
Worked perfectly. Thanks

Sheeloo said:
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)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A data validation question 1
Excel Need Countifs Formula Help 0
Need VBA solution to find 1st and 2nd occurrences of non- zero, thenreturn column header value 4
Help with VBA to find data delete it change font, add lines then looptill end of file 4
Cell Counter/Increment 2
Border formatting row of cells 22
For-Next by a row Counting consecutive Zero in the column 4
Run select query from VBA code where criteria comes from a multi select ListBox 2

Back
Top