See David Robeley's response.
I was jumping back and forth between virtual machines and inadvertently
used the one with LibreOffice without remembering you're using OpenOffice.
My bad.
Sorry about that.
On Mon, Jan 27, 2020 at 4:20 PM WA.TWORSX via AOL
wrote:
> Alan:
>
> I tried in cell H44:
TNX David; I have just been visiting the LibreOffice help
https://help.libreoffice.org/6.2/he/text/scalc/01/func_minifs.html?DbPAR=CALC
and came to that same conclusion.
On 1/27/2020 4:46 PM, David Robley wrote:
Those functions are not available in AOO - but exist in LibreOffice
since
Those functions are not available in AOO - but exist in LibreOffice
since around version 5.2
On 28/1/20 7:50 am, WA.TWORSX via AOL wrote:
Alan:
I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not
working for me. Error508: Error in bracketing is shown.
I also tried with use of
Alan:
I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not working
for me. Error508: Error in bracketing is shown.
I also tried with use of semicolons =MINIFS(G6:G41;G6:G41;">0") rather
than commas; #NAME? error is returned.
No joy here.
I could not find anything as =MINFS( )
Hello Vince,
Thank you for your kind words.
In your sheet notes you describe needing to "segment a formula" into
several ranges. Unnecessary work, I think.
Try the following formulas instead...
In H43, =MAXIFS(G6:G41,G6:G41,">0")
In H44, =MINIFS(G6:G41,G6:G41,">0")
They appear to me to work as
I believe that I am successful with an interim solution to my original
problem.
This DropBox link, I think, will allow you to download my interim
solution, which comes with some caveats and compromises:
lution I could find. More complex formulas might
be
possible that would meet your goal but I'm not familiar enough with Calc
to
readily conceive of them.
On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL wrote:
Hello Alan B:
TNX for reading my query about Calc Help-updating Data.ods.
For r
. As an
> > alternative you could enter DNB in each cell in the row.
>
> AlanB: What is meant by "DNB" ?
>
> > The row of merged cells that demark "half season" needs to change because
> > of #1. If the row is deleted and the season half is indicated by a heavy
suffice.
This is the simplest solution I could find. More complex formulas
might be
possible that would meet your goal but I'm not familiar enough with
Calc to
readily conceive of them.
On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL wrote:
Hello Alan B:
TNX for reading my query abo
suffice.
This is the simplest solution I could find. More complex formulas might be
possible that would meet your goal but I'm not familiar enough with Calc to
readily conceive of them.
On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL wrote:
Hello Alan B:
TNX for reading my query about Calc Help-u
"half season" needs to change because
> > of #1. If the row is deleted and the season half is indicated by a heavy
> > border between week 18 and 19, that would suffice.
> >
> > This is the simplest solution I could find. More complex formulas might
> be
&g
readily conceive of them.
On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL wrote:
Hello Alan B:
TNX for reading my query about Calc Help-updating Data.ods.
For reasons, unknown to me, my pasted example seems to be
plain/unformatted text, although I had sent it out via Mozilla
Thunderbird email
that would meet your goal but I'm not familiar enough with Calc to
readily conceive of them.
On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL wrote:
> Hello Alan B:
>
> TNX for reading my query about Calc Help-updating Data.ods.
>
> For reasons, unknown to me, my pasted example s
Hello Alan B:
TNX for reading my query about Calc Help-updating Data.ods.
For reasons, unknown to me, my pasted example seems to be
plain/unformatted text, although I had sent it out via Mozilla
Thunderbird email client using both HTML and plain text to the AOO
mailing list, and appeared
Hello Vince,
I'm intrigued but not able to follow what you're trying to do. Columns D
through H appear to be the games bowled in any given week, rows (or should
I say weeks) 1 through 21 are the results of the games in those weeks. That
seems clear to me. But whose games, Russ, Vince, Dave, or
At 11:55 18/01/2020 -0500, Vince Bonly wrote:
Note: Cells with a yellow background identify required data must be
entered. Cells with a (darker) gray background identify cells which
show calculated results.
I have a Calc sheet that I enter data on a regular basis, as shown below:
[D] [E] [F]
AOO 4.1.5 on Win10 Home desktop
_
Note: Cells with a yellow background identify required data must be
entered. Cells with a (darker) gray background identify cells which
show calculated results.
I have a Calc sheet that I enter data on a regular basis, as
AOO 4.1.5 on Win10 Home desktop
_
Note: Cells with a yellow background identify required data must be
entered. Cells with a (darker) gray background identify cells which
show calculated results.
I have a Calc sheet that I enter data on a regular basis, as
18 matches
Mail list logo