Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

2 Answers 2

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

=large('A'!$A:$A,11-row())  

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:

=OFFSET(A1,COUNTA(A:A)-10,0,10,1)
share|improve this answer

Your Answer

 
discard

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.