9

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? Mar 2 '13 at 11:58
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
    Mar 2 '13 at 14:52
  • That indeed is another question. Please read this section of the faq how to deal with answered questions. 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. Jul 1 '13 at 23:19
  • @XavierCasto Done, thanks for that !! Jul 2 '13 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, privacy policy and cookie policy

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