Is it possible to set up advanced filtering showing records where an amount is, say >= 2 AND <= 4?
K Kirk P. Nov 19, 2009 #1 Is it possible to set up advanced filtering showing records where an amount is, say >= 2 AND <= 4?
J Jacob Skaria Nov 19, 2009 #2 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
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
P Peo Sjoblom Nov 19, 2009 #3 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 Click to expand... Then select the list, in the advanced filter box use $G$1:$H$2 as criteria That's it! -- Regards, 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 Click to expand... Then select the list, in the advanced filter box use $G$1:$H$2 as criteria That's it! -- Regards, Peo Sjoblom
