On Fri, 20 May 2011 19:49:33 -0700 (PDT) jacare <[email protected]> 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 [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
