Re: How to filter data with criteria J_min < J < J_max

[jacare <walkeystalkey gmail com>]

Oliver Burnett-Hall wrote:
> On Fri, 20 May 2011 19:49:33 -0700 (PDT)
> jacare <walkeystalkey gmail com> wrote:
> > Here's what I tried to do.
> > *Copied the heading row and pasted below the data set.
> > *In the cell below 'J', typed '>14.4', and in the cell below that,
> > typed '<16'.
> > *Chose 'Advanced Filter..' from the menu 'Data -> Filter', and
> > entered the data set as the 'List range', and entered the three cells
> > under (and including) the column 'J' pasted below the data set as the
> > 'Criterea range'. But I get all of the dataset as the filter result.
> > It seems to me that GnuMeric interprets my criterea as '(J > 14.4) OR
> > (J < 16)'. But what I want is '(J > 14.4) AND (J < 16)'. How do I do
> > this?
>
> Multiple rows in advanced filters are combined using OR.  To AND
> multiple criteria you need to put them in different columns, i.e. you
> need this:
>
>   [heading]  [heading]
>   >14.4      <16
>
> The [heading] should be whatever is in the heading row for column J in
> the data table.  You only need those four cells, you don't need to
> include any other columns from the data table.
>
> HTH,
>
> - olly
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list

Thanks.
-- 
View this message in context: 
http://old.nabble.com/How-to-filter-data-with-criteria-J_min-%3C-J-%3C-J_max-tp31668925p31674776.html
Sent from the GnuMeric mailing list archive at Nabble.com.