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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityHow 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?
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)
Shorter version:
=index(Sheet1!A:A,match("z¬",Sheet1!A:A))
BUT relies on ColumnA of Sheet1 being all Text.