Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In one sheet A I have an ongoing number of rows where the 1st column is a timestamp in ascending order (more recent entries at the bottom).

I'd like to have another sheet B where only the 10 most recent entries (per timestamp) appear. Is there a function that can achieve that?

If using the timestamp is not feasible, then the 10 bottom rows, given that those will be the most recent.

share|improve this question
Perhaps you can share a doc with us and show the expected outcome. – Jacob Jan Tuinstra Mar 20 '13 at 10:54

This is another way of doing it.




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).


enter image description here


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

share|improve this answer

If you want the results in rows1:10 please try:


in Row1 and copy down to Row10. If in reverse order leave out 11-. If in some other row either change 11-row() to a number to represent which of the 10 belong in that row (1 being the most recent, 2 the next most recent, etc) so each formula is individually tailored, or use an offset in the formula and then copy, so for the results to show starting in Row7 and continuing downwards use 17-row() instead of 11-row().

share|improve this answer

Since other answer appears not to suit, one adapted from Tim Williams:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.