if isblank question
 

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
--
Thanks for your help!

if isblank question
 

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

This is the same as an ISBLANK test
--
Gary''s Student - gsnu200792


"TamIam" wrote:

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
--
Thanks for your help!

if isblank question
 

This works for the second row, but thereafter displays a blank...any
suggestions?
--
Thanks for your help!


"Gary''s Student" wrote:

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

This is the same as an ISBLANK test
--
Gary''s Student - gsnu200792


"TamIam" wrote:

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
--
Thanks for your help!

if isblank question
 

[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" wrote in message
...
In B1:
=A1
In B2:
=IF(A2="",B1,A2)
and copy down

This is the same as an ISBLANK test
--
Gary''s Student - gsnu200792


"TamIam" wrote:

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
--
Thanks for your help!

if isblank question
 

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 - gsnu200792


"TamIam" wrote:

This works for the second row, but thereafter displays a blank...any
suggestions?
--
Thanks for your help!


"Gary''s Student" wrote:

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

This is the same as an ISBLANK test
--
Gary''s Student - gsnu200792


"TamIam" wrote:

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
--
Thanks for your help!

if isblank question
 

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


"Rick Rothstein (MVP - VB)" wrote:

[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" wrote in message
...
In B1:
=A1
In B2:
=IF(A2="",B1,A2)
and copy down

This is the same as an ISBLANK test
--
Gary''s Student - gsnu200792


"TamIam" wrote:

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
--
Thanks for your help!