In Row1 Column A, enter ...
=MAX(NOT(ISBLANK(C1:AA1))*COLUMN(C1:AA1))
press <Ctrl-Shift-Enter> ... this adds {}'s and makes it an array
Copy this to Column A for each row in use (the row number should
increment automatically)
(this part was pointed to by David Fleck, URL:
<http://minorpoint.blogspot.ca/2010/09/how-to-find-last-used-row-in.html>,
but is converted it to look at columns instead of rows)
In Row1 Column B, enter ...
=INDIRECT(CHAR(A1+64)&ROW())
press <Enter>
... where 64 is the ASCII offset for the letter A
Copy this to Column B for each row in use (the row number should
increment automatically)
Enter data in rows, in columns C to Z ... blanks are allowed.
Column B of each row will contain the value displayed in the last column
of that row that contains data.
Key items:
blank cells are allowed
numeric and character data are allowed
data in columns AA and beyond will cause errors
might be able to work around that, but have not tried at this point
Note: I tried combining the formulas in columns a and b, and I got
formula overflow errors.
I would be interested if anyone finds an error or problem, or has any
comments or suggestions ... thank you.
Tested on OpenOffice Calc 3.4.1, running Mageia2, KDE4
Regards
Fred James
_______________________________________________
PLUG mailing list
PLUG@lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug
