Google-sheets – How to display the first 40 rows from one sheet into another sheet

This is another way of doing it.

Formula

=QUERY(TIMESTAMPS!A:B, "SELECT A, B ORDER BY A DESC LIMIT 10")

Explained

The QUERY formula needs the data from the timestamps sheet, for it to process. The result must contain column A and B, of which column A is sorted descendingly (new to old). Finally, the result is limited to 10 entries (rows).

Screenshot

Example

I've created an example file for you: how to show the 10 most recent rows

I found three solutions for you.

Formula

=INDIRECT("DATA!A"&A1)

Google Apps Script

function dataSubset(data,subset) {
  var output = [];
  for(var i=0, iLen=subset.length; i<iLen; i++) {
    for(var j=1, jLen=data.length+1; j<jLen; j++) {
      if(parseInt(subset[i]) == parseInt(j)) {
        output.push(data[j-1]);
      }
    }
  }
  return output;
}

Formula only available in the new Google Spreadsheet

=ARRAY_ROW(INDIRECT("DATA!A"&A1),INDIRECT("DATA!B"&A1))

Example

I've prepared two example files for you:

1. Old
2. New