Advanced Filtering

[Kirk P.]

Is it possible to set up advanced filtering showing records where an amount
is, say >= 2 AND <= 4?

 

[Jacob Skaria]

Data>Filter>AutoFilter>In the number column click the drop down> click
(Custom...)

1st condition select 'is greater than or equal to' 2
2nd condition select 'is less than or equal to' 4

If this post helps click Yes

 

[Peo Sjoblom]

Yes, in the criteria range use the header of the particular column you want
to filter for, let's call it Header, assume you put that in G1:H2 and it
would look like this


Header Header

=2 <=4

Then select the list, in the advanced filter box use


$G$1:$H$2


as criteria



That's it!

--


Regards,


Peo Sjoblom