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 ***
