Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert cell text every 5 rows in a column | Excel Discussion (Misc queries) | |||
Counting non-blank cells in a column, excluding hidden rows | Excel Worksheet Functions | |||
Warning message if one column contains any text and another column is blank | Excel Worksheet Functions | |||
To delete rows when more than one cell is blank | Excel Worksheet Functions | |||
Auto Filter out text or blank rows | Excel Discussion (Misc queries) |