Hi Louis,
You can do that with indirect addressing:
=INDIRECT("a" & ROW()*3)
tc
You appear not to be subscribed to the users' mailing list. You could
miss many of the replies to your post unless you do subscribe. Just
send a blank message addressed to <[EMAIL PROTECTED]> using
the e-mail account through which you want to receive it. You will
receive a message asking you to confirm your subscription by replying to
it. See http://support.openoffice.org/index.html for more options.
Subscribing is optional. Be aware that after subscribing, you may
receive many messages from the list. Be prepared to set up mail filters
in your email client in order to deal with them.
louis lavoisier wrote:
I am using version 1.1 of OpenOffice.org. My problem is I would like to
only copy every third data entry from a column. ie b1=a3, b2=a6, b3=a9 .
. . bi = b 3*i
is this possible and if so how?
Thanks for your help
louis
_________________________________________________________________
Advertisement: Makeover Your Finances - WIN a $3000 Planning Package
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fwww%2Eletsshop%2Ecom%2FDefault%2Easpx%3Ftabid%3D948&_t=764144777&_r=letshop_emailtaglines_june07&_m=EXT
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
