Oliver Burnett-Hall wrote: > > On Fri, 20 May 2011 19:49:33 -0700 (PDT) > jacare <walkeystal...@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. _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
