| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overriding zero-strings with previous line constant
In my Col-A I have the below formula copied down 10,000 rows
I get either 1-1234 or "" (zero-strings) as a result. I want to repeat the occasional change in the numbers 1-1234 (row 10) and 1-2222 (Row1200) to OVERRIDE the zero-strings. How can this be done I thought of using Special Cells Blank - but such of course doesn't work to select the zero-strings as they ARE NOT BLank. Any help appreciated on this.. =IF(MID(C12,2,1)="-",C12,"") |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Overriding zero-strings with previous line constant
Maybe...
=IF(MID(C12,2,1)="-",C12,c11) You may have to use a different formula in the top cell--just to "prime the pump". Jim May wrote: In my Col-A I have the below formula copied down 10,000 rows I get either 1-1234 or "" (zero-strings) as a result. I want to repeat the occasional change in the numbers 1-1234 (row 10) and 1-2222 (Row1200) to OVERRIDE the zero-strings. How can this be done I thought of using Special Cells Blank - but such of course doesn't work to select the zero-strings as they ARE NOT BLank. Any help appreciated on this.. =IF(MID(C12,2,1)="-",C12,"") -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Overriding zero-strings with previous line constant
Thanks Dave for the "Wake-Up" Call;
Got it going.. Jim "Dave Peterson" wrote: Maybe... =IF(MID(C12,2,1)="-",C12,c11) You may have to use a different formula in the top cell--just to "prime the pump". Jim May wrote: In my Col-A I have the below formula copied down 10,000 rows I get either 1-1234 or "" (zero-strings) as a result. I want to repeat the occasional change in the numbers 1-1234 (row 10) and 1-2222 (Row1200) to OVERRIDE the zero-strings. How can this be done I thought of using Special Cells Blank - but such of course doesn't work to select the zero-strings as they ARE NOT BLank. Any help appreciated on this.. =IF(MID(C12,2,1)="-",C12,"") -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| remove line breaks in text strings | New Users to Excel | |||
| Extracting Constant from Non-linear Trend line | Charts and Charting in Excel | |||
| how do I plot a constant value in a line graph? | Charts and Charting in Excel | |||
| How do I start new line when concatenating text strings in excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
