Re: [libreoffice-users] Calc - Find last entry in a column - how?

I cant get this to work on my Mac - all  I end up with err:502




On 2 Mar 2011, at 21:55, Stefan Weigel wrote:

> Hi Pete,
>
> Am 02.03.2011 19:50, schrieb Pete Bradbury:
>
> > What function will enable me to access the data in the last used
> > cell of a column of data?
>
> For the value of the last used cell of column A use this formula in
> any other cell outside of column A:
>
> {=OFFSET($A$1;MAX(IF($A$1:$A$1048576<>"";ROW($A$1:$A$1048576);0))-1;0;1;1)}
>
> Note: This is a Matrix Formula
> http://help.libreoffice.org/Calc/Entering_Matrix_Formulas
>
> Type in the formula without the brackets { }. End the input with the
> matrix key combination: Shift+Ctrl+Enter. If successful, the
> brackets { } will appear.
>
> Good luck!
>
> Stefan
>
> -- 
> LibreOffice - Die Freiheit nehm' ich mir!
>
> -- 
> Unsubscribe instructions: E-mail to users+help@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***


-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***