RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Hi guys, got a double whammy here.
I'm using AutoFilter to chop down a 300,000 line database to the relevant fields - bought within a timeframe, are eligible to be mailed, etc.
I also want to use Advanced Filter to filter through six different product columns so that one filter doesn't exclude the other - so if a customer has bought a "N" product, or a "P" product, they aren't filtered out, whereas if I used regular autofilter they would have had to have bought "N" AND "P".
The problem here is that if I use one type of filter, it removes the other, whereas just using Autofilter results in additive filtering which is useful for chopping down a list of clients.
Also I'm having an issue with my advanced filter. I figured if there's no way to make advanced & autofilters play nice, then I can write out the criteria and apply the big filter that way, using it for both "OR" & "AND" operations.
No matter what, I can't get the following critieria to apply:
The column header is definitely correct and <>0 should be a legal operation. If I use a regular filter and select "Does not contain" and then write "0" - it produces the same result. I need to find 1's and blanks.
Cheers!
I'm using AutoFilter to chop down a 300,000 line database to the relevant fields - bought within a timeframe, are eligible to be mailed, etc.
I also want to use Advanced Filter to filter through six different product columns so that one filter doesn't exclude the other - so if a customer has bought a "N" product, or a "P" product, they aren't filtered out, whereas if I used regular autofilter they would have had to have bought "N" AND "P".
The problem here is that if I use one type of filter, it removes the other, whereas just using Autofilter results in additive filtering which is useful for chopping down a list of clients.
Also I'm having an issue with my advanced filter. I figured if there's no way to make advanced & autofilters play nice, then I can write out the criteria and apply the big filter that way, using it for both "OR" & "AND" operations.
No matter what, I can't get the following critieria to apply:
Landmail_Optin |
<>0 |
The column header is definitely correct and <>0 should be a legal operation. If I use a regular filter and select "Does not contain" and then write "0" - it produces the same result. I need to find 1's and blanks.
Cheers!