Mark,
=(COUNT(A1:A65536)+1) will find how many rows have a number, no need to
be an incrementing number. =COUNTA(A1:A65536) will return the number of
rows that are non empty, that includes itself and cells that have space
in them.
Hope this helps.
Andy
Mark Knecht wrote:
So one obvious, but not very generic solution was to realize that the
data always starts with the value 1 in cell A3, so =MAX(A3:A10000)
returns the highest value and I can add 2 to that to get the row
address.
I'd rather find a more interesting and generic solution to this though
as I don't always have a value incrementing in the first column.
--
Andy Brown
La Mesa, CA 91942
www.the-martin-byrd.net/openoffice.org.html
OpenOffice.org Community Distributor
CD/OEM Distribution Project member
Documentation Project member
Marketing Project member
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
