David,
A follow up to my first reply. I wanted to investigate a bit more to see if
I could produce a macro that actually incremented values in column B based
on the corresponding cell in column D being changed.
This works for me incrementing the value in col B by +1 when the value in
column D on
Generally, The following should work, but spelling or spacing differences
won't be ignored. any difference in the name will be treated as a new
reviewer.
IF(A1=A2,B1+1,1)
On Tue, Dec 10, 2019 at 10:51 PM zed wrote:
> Hi!
>
> Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate
>
> I have a spre
Hi David,
As I understand it you have values in column B and dates in column D. When
a new date is entered in a cell in column D or an existing date is changed
you want the cell on the corresponding row in column B to increase by 1.
e.g. B1 = 5, D1 = May 5, 2019
change D1 and B1 becomes 6.
- or -
Den tors 12 dec. 2019 kl 05:38 skrev zed :
> Brian Barker wrote:
>
> > At 17:49 11/12/2019 +1300, David Noname wrote:
> > > I have a spreadsheet in Calc ... It has Columns ... B - No, formatted
> > > number general ...
> > >
> > > Is there a formula that I can enter in Column B which will increas
At 17:35 12/12/2019 +1300, David Noname wrote:
Thank you for your prompt reply, Brian. It is much appreciated
No probs!
Perhaps I didn't explain myself clearly enough. In simple terms, I
want to know whether there is any way that when I enter a new date
in Column D it will automatically inc
Johnny Rosenberg wrote:
> Den ons 11 dec. 2019 kl 05:51 skrev zed :
>
> > Hi!
> >
> > Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate
> >
> > I have a spreadsheeet in Calc which records data of reactions to a
> > particular performer. It is in the form: It has Columns A - G.
> >
> > A - Nam
Brian Barker wrote:
> At 17:49 11/12/2019 +1300, David Noname wrote:
> > I have a spreadsheet in Calc ... It has Columns ... B - No, formatted
> > number general ...
> >
> > Is there a formula that I can enter in Column B which will increase
> > incrementally increase the figure by 1, please?
>
Den ons 11 dec. 2019 kl 05:51 skrev zed :
> Hi!
>
> Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate
>
> I have a spreadsheeet in Calc which records data of reactions to a
> particular performer. It is in the form: It has Columns A - G.
>
> A - Name, fformatted as Text (records thre name of th
At 17:49 11/12/2019 +1300, David Noname wrote:
I have a spreadsheet in Calc ...
It has Columns ...
B - No, formatted number general ...
Is there a formula that I can enter in Column B which will increase
incrementally increase the figure by 1, please?
I think you are saying that you want valu