=LOOKUP(REPT("Z",255),A:A)

will display last text entry in selected range

HTH

"Tom" wrote:

How do I set up a cell to display the last entry (of text) in a column,
regardless of what the text says...and have it update daily as more rows are
added to the column, and as the text entry may change...based on the formula?

Can anyone assist me with this?

Tom