Advanced Filtering

  • Thread starter Thread starter Kirk P.
  • Start date Start date
K

Kirk P.

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


Then select the list, in the advanced filter box use


$G$1:$H$2


as criteria



That's it!

--


Regards,


Peo Sjoblom
 
Back
Top