Advanced Filtering
 

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

Advanced Filtering
 

DataFilterAutoFilterIn 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
---------------
Jacob Skaria


"Kirk P." wrote:

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

Advanced Filtering
 

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


"Kirk P." wrote in message
...
Is it possible to set up advanced filtering showing records where an
amount
is, say = 2 AND <= 4?