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,"")

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

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