I don’t want to use app script function. There should be a way with index / counta / or Max to target the last cell in Col1 and then return the data of the last row that it is on.
I need to target ColA because every entry will have a timestamp in this column so there will be no blank cells.
https://docs.google.com/spreadsheets/d/1kY6yOkCzXvpyFEM4wOn8ZbT4wmHntiZIk4qoZyMJzH8/edit?usp=sharing
Once I have a solution how do I adjust that formula so that I get the last 2 rows or the last 4 rows.
Important: the table isn’t static. It grows often by rows
I tried functions but felt like overkill
Bryant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.