Overriding zero-strings with previous line constant

  • Thread starter Thread starter Jim May
  • Start date Start date
J

Jim May

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,"")
 
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".
 
Back
Top