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 [email protected]
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
--
Unsubscribe instructions: E-mail to [email protected]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
