[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
- Subject: Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
- From: zed <firstname.lastname@example.org>
- Date: Thu, 12 Dec 2019 17:42:41 +1300
- To: Johnny Rosenberg <email@example.com>
- Cc: LibreOffice Användare <firstname.lastname@example.org>
Johnny Rosenberg <email@example.com> wrote:
> Den ons 11 dec. 2019 kl 05:51 skrev zed <firstname.lastname@example.org>:
> > Hi!
> > Using LibreOffice v22.214.171.124 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 the persons doing the
> > reaction) B - No, formatted number general (records number of times this
> > reactors has reacted to the performer) C - First, formatted DD/MM/YY
> > (records the first date the reactor reaacted to this performer) D -
> > Last, formatted DD/MM.YY (records last date reactor reacted to this
> > performer) E - Days, formatted =NOW()-D3 (records number of days since
> > last reaction) F - Weeks, formatted =E3/7 (records number of weeks since
> > last reaction) G - Months, formatted =F3/4 (records number of months
> > since last reaction. reaction)
> > Is there a formula that I can enter in Column B which will increase
> > incrementally increase the figure by 1, please?
> > Regards from New Zealand on a very warm summer evening.
> > David -- Zed
> I'm not sure I understand what you are asking for here. So in column A,
> there are names, as you said, and in column B there's a number that tells
> you how many times the name in Column A appeared so far? Then I guess the
> following would work: B1: =IF(A1="";"";COUNTIF(A$1:A1;A1)) Click and drag
> the formula downwards. Now, for instance B17 looks like this:
> =IF(A17="";"";COUNTIF(A$1:A17;A17)) The IF is just to not display a zero
> when nothing is entered into the corresponding A line.
Thank you for your quick response.
Unfortunately that didn't work. That was probably because I didn't explain
myself carefully enough.
Have a look at my answer to Brian Barker, where I try to be clearer in what
I'm trying to achieve.
If there is a solution I will think all my Christmases have come at once!
But I am resigned to the fact that there probably isn't.
"I have often regretted my speech, never my silence." Xenocrates (396-314
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
|[libreoffice-users] LibreOffice Calc - Date - increase number times...||zed <firstname.lastname@example.org>|
|Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...||Johnny Rosenberg <email@example.com>|
- Prev by Date: Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
- Next by Date: [libreoffice-users] adapting userinterface by uno or registry
- Previous by thread: Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
- Next by thread: Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...