Text to appear three rows after last blank cell in column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Monk - 15 May 2008 23:17 GMT

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?

Reply to this Message

BoniM - 16 May 2008 00:43 GMT

=IF(AND(A3="",A2="",A1<>""),IF(A1="Warning:","","Warning:"),"")
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.

> 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.
[quoted text clipped - 4 lines]
>
> What would be the easiest way to achieve this?

Reply to this Message

Monk - 16 May 2008 04:04 GMT

Thanks BoniM. Just what I need.

> =IF(AND(A3="",A2="",A1<>""),IF(A1="Warning:","","Warning:"),"")
> Copy in cell below existing text in column A and then copy down... as data
[quoted text clipped - 9 lines]
> >
> > What would be the easiest way to achieve this?

Reply to this Message

Pete_UK - 16 May 2008 00:49 GMT

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

Pete

Reply to this Message