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.

I'm looking for help on the following:

How do I get the last date from a column in sheet1 returned in a cell of sheet2

I tried it with:

=FILTER(Sheet1!A:A ; ROW(A:A) =MAX( FILTER(ROW(A:A) ; NOT(ISBLANK(A:A)))))

but this results in an error

Any suggestions?

share|improve this question
    
What kind of error? Could you share the spreadsheet with us? –  Vidar S. Ramdal Mar 2 '13 at 11:58
add comment

1 Answer 1

up vote 1 down vote accepted

The following formula will find the maximum date in column A:

=MAX(ARRAYFORMULA(A2:A))

See example file I've prepared: find maximum date

share|improve this answer
    
Thank you, you´re my hero ! :-) –  ibitom Mar 2 '13 at 14:50
    
It works like a charm. Do you have an idea what I can do if the collumn doesn´t contain dates, but text ? –  ibitom Mar 2 '13 at 14:52
    
That indeed is another question. Please read this section of the faq how to deal with answered questions. –  Jacob Jan Tuinstra Mar 2 '13 at 19:28
    
You´re right. I have posted a new question. Thanks. –  ibitom Mar 3 '13 at 8:02
    
@JacobJanTuinstra, you might want to change the "share" permissions on the example you've prepared. –  Xavier Casto Jul 1 '13 at 23:19
show 1 more comment

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.