Return the Last TEXT Value in a Column

On a number of forums, I found the following suggested formulas for returning the last TEXT value in a column. These are pretty good and they allow the range to include blanks, error values (like #N/A), and numeric values.=VLOOKUP(REPT("z",255),A:A,1) or=INDEX(A:A,MATCH(REPT("z",255),A:A))(For the formula that returns the last NUMERIC value in a column, see my previous post)I prefer the formula