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
