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

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

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.


- olly
gnumeric-list mailing list
gnumeric-list gnome org

View this message in context:
Sent from the GnuMeric mailing list archive at

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]