Text to appear three rows after last blank cell in column
 

I would like certain text to appear (only once) in a cell in column A, three
rows after the last value is entered in that column.

i.e if the last value entered by a user appears in a3, I would like text
(say "Warning:") to appear in cell a6. If the user enters a value in a4, the
text will now appear in a7.

What would be the easiest way to achieve this?

Text to appear three rows after last blank cell in column
 

=IF(AND(A3="",A2="",A1<""),IF(A1="Warning:","","W arning:"),"")
Copy in cell below existing text in column A and then copy down... as data
is entered - Warning will move down. Since the formula will be replaced as
data is entered, if you delete data, you may need to repopulate with formula.


"Monk" wrote:

I would like certain text to appear (only once) in a cell in column A, three
rows after the last value is entered in that column.

i.e if the last value entered by a user appears in a3, I would like text
(say "Warning:") to appear in cell a6. If the user enters a value in a4, the
text will now appear in a7.

What would be the easiest way to achieve this?

Text to appear three rows after last blank cell in column
 

A formula cannot "push" a value to another cell, so you would have to
use a macro to do this.

Pete

On May 15, 11:17*pm, Monk wrote:
I would like certain text to appear (only once) in a cell in column A, three
rows after the last value is entered in that column.

i.e if the last value entered by a user appears in a3, I would like text
(say "Warning:") to appear in cell a6. If the user enters a value in a4, the
text will now appear in a7.

What would be the easiest way to achieve this?

Text to appear three rows after last blank cell in column
 

Thanks BoniM. Just what I need.

"BoniM" wrote:

=IF(AND(A3="",A2="",A1<""),IF(A1="Warning:","","W arning:"),"")
Copy in cell below existing text in column A and then copy down... as data
is entered - Warning will move down. Since the formula will be replaced as
data is entered, if you delete data, you may need to repopulate with formula.


"Monk" wrote:

I would like certain text to appear (only once) in a cell in column A, three
rows after the last value is entered in that column.

i.e if the last value entered by a user appears in a3, I would like text
(say "Warning:") to appear in cell a6. If the user enters a value in a4, the
text will now appear in a7.

What would be the easiest way to achieve this?