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

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


"Kirk P." wrote:

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

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." <(E-Mail Removed)> wrote in message
news:B5D9801E-4FFA-438C-B158-(E-Mail Removed)...
> Is it possible to set up advanced filtering showing records where an
> amount
> is, say >= 2 AND <= 4?