Re: advanced filters intervals

[Oliver Burnett-Hall <olly burnett-hall co uk>]

vincent hautiere <vhautiere gmail com> wrote:

> I have a problem with advanced filters. I want to use a criteria
> 1000<J<2000 but if i use two criteria in the column : J<2000 and
> J>1000,
> gnumeric do J>1000 OR J<2000. I want to do J>1000 AND J<2000. I don't
> know
> how.

You need to use two columns in the filter criteria for this: J<2000 in one column and J>1000 in the other.

HTH,

-- 

- olly