| 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. |
| 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 | |||
Threaded Mode
