if isblank question

T

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
 
G

Gary''s Student

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

This is the same as an ISBLANK test
 
R

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
 
G

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.
 
G

Gary''s Student

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


Rick Rothstein (MVP - VB) said:
[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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top