[users] Re: Row number of last non-blank cell in column?

[Joe Smith]

On 06/24/2009 01:31 PM, Mark Knecht wrote:

Hi,
    I wonder if anyone knows of a function I might use to find the row
number of the last non-blank cell in a column?
...

Try

=MAX(NOT(ISBLANK(A1:A65536))*ROW(A1:A65536))

as an array formula--use Ctrl+Shift+Enter to enter the formula.

<Joe


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org