Thank you.
Regards,
Vince
Sent from my iPad
> On Jun 5, 2016, at 14:17, Dennis E. Hamilton wrote:
>
>
>
>>
>
> In case this remains a question. >100 does not include 100 and <109 does not
> include 109.
>
> So long as the values are integers, >99 and <110 cover 100 to 109 inclusive.
>
> -Original Message-
> From: Vince [mailto:wa.two...@verizon.net]
> Sent: Sunday, June 5, 2016 10:18
> To: users@openoffice.apache.org
> Subject: Re: Search & Replace Formula in Cell with a Named Array
>
> (I reported in an earlier posting, /Detecting/Counting C
Thank you Brian!
On 6/5/2016 2:07 AM, Brian Barker wrote:
Yes. But you won't need to replace the formula, of course, just the
ranges it includes.
In the Find & Replace dialogue, click More Options and select Formulae
in the "Search in" drop-down.
Aha! You're correct, of course.
You may wish
(I reported in an earlier posting, /Detecting/Counting Cell's Values if
data is within a Specific Range of Values,/ that the Play File I created
was working. I now find that there are erroneous calculations in the
file that I am now using (a larger array of data) .
Also, please note that the
At 13:38 04/06/2016 -0400, Vince Bonly wrote:
Using the Find&Replace feature in AOO 4.1.2 Calc, is it possible to
replace a formula, such as:
=SUMPRODUCT($D$343:$L391>100;$D$343:$L391<109)
with:
=SUMPRODUCT(_2016_Scores_Target_Vince>100;_2016_Scores_Target_Vince<109)
where:
_2016_Scores_Target_V
Using the Find&Replace feature in AOO 4.1.2 Calc, is it possible to
replace a formula, such as:
=SUMPRODUCT($D$343:$L391>100;$D$343:$L391<109)
with:
=SUMPRODUCT(_2016_Scores_Target_Vince>100;_2016_Scores_Target_Vince<109)
where:
_2016_Scores_Target_Vince
is a named array ($D343:$L391) ?
