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?
Google-sheets – How get last added text from column into different sheet
google sheets
Related Topic
- Google Sheets – Combine Text from Multiple Cells into Single Cell
- Google-sheets – How to count the number of empty rows since the last entry in a column
- Google-sheets – Skip empty rows while copying
- Google-sheets – How to get current date to be added to a cell when a check box is checked in another cell
- Google Sheets – How to Pull Values for Dynamic Data Validation
- Google Sheets Concat – How to Concat Text from Column with Non-Empty Cells
- Google-sheets – How to apply arrayformula on a hyperlink so that I can reference another cell in a different sheet
Best Answer
This formula works perfect:
(found the answer somewhere else)