I find OFFSET() quite useful whenever I build a table with a running
balance (for instance where the balance in X10 = X9+W10). Without the
OFFSET() function, if I needed to insert a row between rows 9 & 10, the
new row would not be included in the running balance unless I edited the
formula.
nt: Sat, 25 Apr 2015 12:17
Subject: Re: [libreoffice-users] selecting cells in calc sheet
On Sat, 25 Apr 2015 11:46:23 -0700
James E Lang wrote:
> The main thing I'm not understanding is whether the formula is to be one fixed
> place or if after 3 data points it is in cell X but after
nt: Sat, 25 Apr 2015 12:17
Subject: Re: [libreoffice-users] selecting cells in calc sheet
On Sat, 25 Apr 2015 11:46:23 -0700
James E Lang wrote:
> The main thing I'm not understanding is whether the formula is to be one fixed
> place or if after 3 data points it is in cell X but after
: Re: [libreoffice-users] selecting cells in calc sheet
On Sat, 25 Apr 2015 10:53:38 -0700
James E Lang wrote:
> You did not correct any of my suppositions so here is my very detailed
> recommendation. Note that my quotation marks surrounding text are NOT to be
> keyed
> into the spr
nikolic
To: James E Lang
Sent: Sat, 25 Apr 2015 8:38
Subject: Re: [libreoffice-users] selecting cells in calc sheet
On Sat, 25 Apr 2015 01:30:53 -0700
James E Lang wrote:
> Pete,
>
> Pardon me. I'm confused.
>
> When you say C5 (for example) which do you mean, Row 5 in Column
Apr 2015 23:43
Subject: Re: [libreoffice-users] selecting cells in calc sheet
On Fri, 24 Apr 2015 20:36:10 -0700
James E Lang wrote:
> Pete,
>
> You still leave a lot unsaid such as whether the result is in a single fixed
> location, what if anything is in the even numbered rows of colum
ri, 24 Apr 2015 14:20
Subject: Re: [libreoffice-users] selecting cells in calc sheet
pete nikolic wrote:
> if we start as will be the case C3 will contain say 50 (the actual
> dates are
> of little importance ) a month later C5 will be say 47 and so on every
> month
pete nikolic wrote:
> if we start as will be the case C3 will contain say 50 (the actual
> dates are
> of little importance ) a month later C5 will be say 47 and so on every
> month
> the next cell would be C7 then C9 then C11 what i need is to be able to
> automatically pic
On Fri, 24 Apr 2015 21:52:47 +0100
Brian Barker wrote:
> At 21:00 24/04/2015 +0100, Pete Nikolic wrote:
> >I need to be able to select the last 3 in a series of cells that
> >change on a weekly basis so in
> >week 1: there would be 1 cell - no action
> >week 2: 2 cells - no action
> >week 3: 3 c
At 21:00 24/04/2015 +0100, Pete Nikolic wrote:
I need to be able to select the last 3 in a series of cells that
change on a weekly basis so in
week 1: there would be 1 cell - no action
week 2: 2 cells - no action
week 3: 3 cells - sum three cells
week 4: 4 cells - sum last three
week 5: 5 cells
pete nikolic wrote:
>
> Hi Folks ..
>
>
> I need to be able to select the last 3 in a series of cells that change on
> a weekly
> basis
>
>
>
> so i week 1 there would be 1 cell no action
> week 2 2 cells no action
> week 3
Hi Folks ..
I need to be able to select the last 3 in a series of cells that change on a
weekly
basis
so i week 1 there would be 1 cell no action
week 2 2 cells no action
week 3 3 cell sum three cells
week 4
12 matches
Mail list logo