| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change FIND indicator | Excel Discussion (Misc queries) | |||
| change error message when no more for "find" in macro to find | Excel Programming | |||
| Find a Name, Duplicate a Row, Change a Value | Excel Worksheet Functions | |||
| how to change "Find" feature | Excel Worksheet Functions | |||
| Find & Replace w/ name change | Excel Programming | |||
Linear Mode
