10

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?

1
  • What kind of error? Could you share the spreadsheet with us? Commented Mar 2, 2013 at 11:58

2 Answers 2

10

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

=MAX(ARRAYFORMULA(A2:A))

See example file I've prepared: find maximum date

6
  • It works like a charm. Do you have an idea what I can do if the collumn doesn´t contain dates, but text ?
    – ibitom
    Commented Mar 2, 2013 at 14:52
  • That indeed is another question. Please read this section of the faq how to deal with answered questions.
    – Jacob Jan
    Commented Mar 2, 2013 at 19:28
  • You´re right. I have posted a new question. Thanks.
    – ibitom
    Commented Mar 3, 2013 at 8:02
  • @JacobJanTuinstra, you might want to change the "share" permissions on the example you've prepared. Commented Jul 1, 2013 at 23:19
  • @XavierCasto Done, thanks for that !!
    – Jacob Jan
    Commented Jul 2, 2013 at 5:24
0

To find the last value entered in col A (of sheet1), also try

=+sort(Sheet1!A:A,row(Sheet1!A:A)*(Sheet1!A:A<>""),)

and see if that works ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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