google-sheetsgoogle-sheets-formulaworksheet-function
Display last five rows in Google Sheets
I have a simple personal money tracker based on Google form for data input and spreadsheet for calculating, statistics and so.
Everything works just fine but now I need workaround to display the last five entries in sheet that contain raw data from Google form.
This is what the sheet looks like:
What I want to do is create new spreadsheet which displays the last five entries from the sheet with data from Google form. Please help me with right formula for this.
P.S: Would be perfect display this information right in Google form that I used to enter data but as far as I know its impossible.
Solution
If there are no gaps in the time column, you could try
=query(A:D,"select * offset "&count(A:A)-5)
