Hi there.
I desperately need a macro (preferably in OpenOffice Basic) returning
value of the last non-empty cell specified. More precisely let our
sheet look as follows:
|A|B|C|D|E|F
--+-+-+-+-+-+-
1 | |6| |1| |
In this case: LAST(A1;C1;D1;F1)=1 and LAST(A1;B1;C1)=6. In the case when
all cells specified are empty LAST should return 0. Moreover it should
accept variable arguments number (like SUM but without the possibility
of specifying regions).
Thanks in advance for any help.
Regards
Greg
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
