How get last added text from column into different sheet

Question

How can I get the last added plain text from a column in sheet1, which also has empty rows, into a cell of a sheet2?

With help I managed to do this with the last added date, but with plain text I am stuck.

Any Suggestions?

Still very interested in answer..... Am trying to help a friend getting his business a bit more organized. Tnx.

Jacob Jan Tuinstra · Answer 1 · 2013-03-07 12:16:32Z

up vote 0 down vote

This formula works perfect:

=IFERROR(INDEX(FILTER(Sheet1!A:A,Sheet1!A:A<>""),
         COUNTA(FILTER(Sheet1!A:A,Sheet1!A:A<>""))))

(found the answer somewhere else)

edited Mar 7 at 12:16

Jacob Jan Tuinstra
2,9931736

answered Mar 5 at 13:58

ibitom
1

1 Answer