if isblank question

[TamIam]

Good day,

Would anyone know of a way to include the if(isblank()) in reference to a
column with every fourth cell populated with a value that needs to be
replaced in the formula to the right of the column...?? for example,

a b
1 1
1
1
2 2
2
2

and so on....??

Kind regards

 

[Gary''s Student]

In B1:
=A1
In B2:
=IF(A2="",B1,A2)
and copy down

This is the same as an ISBLANK test

 

[TamIam]

This works for the second row, but thereafter displays a blank...any
suggestions?

 

[Rick Rothstein \(MVP - VB\)]

[Off Topic for this Thread]

Message to Gary''s Student...

In case you were not planning on revisiting your "Same Contents, Regardless
of Order" thread over in the m.p.e.programming newsgroup, I posted a message
there that I think you should read.

Rick

 

[Gary''s Student]

Make sure that calculation is set to Automatic

Make sure the formulas are adjusting as you copy downward in column B.
Column B should look like:

=A1
=IF(A2="",B1,A2)
=IF(A3="",B2,A3)
=IF(A4="",B3,A4)
=IF(A5="",B4,A5)
=IF(A6="",B5,A6)
=IF(A7="",B6,A7)
=IF(A8="",B7,A8)
=IF(A9="",B8,A9)
=IF(A10="",B9,A10)

Also make sure the "blank" values in column A are REALLY blanks and not
single spaces.

 

[Gary''s Student]

Thanks....I will check it out right now.
--
Gary''s Student - gsnu200792

[Off Topic for this Thread]

Message to Gary''s Student...

In case you were not planning on revisiting your "Same Contents, Regardless
of Order" thread over in the m.p.e.programming newsgroup, I posted a message
there that I think you should read.

Rick