I'm using Google Sheets. Every week I add a column with new data, and I need the data from the latest column copied into another sheet. The formula needs to pull the cell of the last column in the row.
I've googled left and right and tried and tried.
The "best" formula that I have tried is:
=index(2:2,counta(2:2))
But I get:
error: Reference out of range
I've tried =index(2:2, 5), as a test, which should bring the data from row 2 column 5, no luck.