Terry, you are right--it is only a matter of convenience. But if OO
can handle
non-contiguous ranges (which I see it does from the documentation,
though CTRL-click does not work on Mac OS) then I assume it can handle
non-contiguous ranges wherever a range specification is required. That
may be a bad assumption, but I'd like to try and see.
My problem is that I do not know how to specify a non-contiguous range
on Mac OS. I'd be happy to know either the mouse/keyboard sequence
for graphically creating a non-contiguous range OR the text syntax for
specifying such a range. I can't find either in the documentation
(except
for the graphical CTRL-click, which as I mentioned doesn't work on
Mac OS.)
Josh
On Feb 8, 2007, at 1:34 AM, TerryJ wrote:
I find the method awkward enough already. I have all the criteria
ranges in
the same part of the document and never need to see them. All
you're trying
to achieve is not repeating the first row of the first criterion
range. I
doubt that the programmers have been so obliging as to enable you
to do
that.
If you want to use range names for the criteria ranges, Insert >Names
Define seems not to permit naming disjunctive ranges.
Joshua Simons wrote:
My understanding is that a criteria specification containing multiple
rows will OR together the criteria and that's not what I need. I
have a
set of criteria that I want to evaluate separately against the same
database
using separate DAVERAGEs(). Rather than creating the following rows:
column headings | this is the criteria specification for my
criteria #1 | first use of DAVERAGE().
column headings | this is the criteria for the 2nd
criteria #2
column headings | and for the 3rd.
criteria #3
(etc)
I'd like to list the headings only once and then specify the
criteria ranges using that heading row paired with each
of the criteria rows. To do that, I need to specify the criteria
range as two non-contiguous rows.
On Feb 7, 2007, at 7:10 PM, TerryJ wrote:
Joshua Simons wrote:
Is it possible to specify non-contiguous cell-ranges in OO under
Mac
OS X?
In particular, I would like to specify a non-contiguous range
for the
3rd
argument to DAVERAGE()...
Josh Simons
The third argument is a range which contains your criteria. It
has to
mirror the range containing the values you wish to average. Here
is an
example of a criteria range I use for DAVERAGE:
DATE HIGH LOW CLOSE OPEN VOL MOVE VALUE
=07/11/2006
The first row contains the column headings of the range containing
values. The second row contains criteria. Subsequent rows
contain sets
of
alternative criteria.
The criteria range is critDateCalcs. Part of a typical formula
using the criteria is
=DAVERAGE(BTVdly;"VALUE";critDateCalcs)
That finds the average of values in the column VALUE in the
table BTVdly
which occur on and after the date 7/11/6 in the DATE column of
the table.
(The date in the criteria range is calculated by a formula.)
Regards.
--
View this message in context: http://www.nabble.com/Entering-non-
contiguous-ranges-in-Calc-tf3190506.html#a8860189
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
