Hi,
I need to filter a table by multiple OR contains values.
The filter only lets me put in two values.
Is there a way to filter for say 6 different terms?
Thanks
Hi,
I need to filter a table by multiple OR contains values.
The filter only lets me put in two values.
Is there a way to filter for say 6 different terms?
Thanks
I have never had a problem applying multiple filters to the same column, but maybe add a helper column, and use that to test for what you want - then filter on that?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are only two input boxes though? How can you add more?
Thanks
If there are only two check boxes in the filter, that means that there are only two unique items in that column.
Hmmm, I think we're looking at different filters.
This is what I see, I've only ever seen two input fields to filter by?
Screen Shot 2017-11-14 at 07.40.29.png
Perhaps we could be of more help if you would upload a sample spreadsheet and tell us what values you would like a filter to display.
To upload a sample spreadsheet click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Sure, I've put an example together please find attached.
As Ford mentions in post #2, a way to filter would be to set up helper columns and filter on those.
In the attached copy of your file the formula that populates the helper columns is:Formula:Please Login or Register to view this content.
Then select only the 1 from the filter drop down in either cell C6 or D6.
Let us know if you have any questions.
Super, thanks JeteMc. I wasn't sure what Ford meant be a helper column but it makes sense now!
Is there a way to filter both columns for 1 or can is it only possible to do one at a time?
Yes, providing that there is some overlap. That is that after filtering one column, if there are some items in the second column that will return a 1 from the formula. Example: Change cell B2 to the word 'result'. You should then be able filter columns C and D by showing items with a value of 1.
Let us know if you have any questions.
I thought that might be the case, thanks.
I'll have to filter them seperately I think then as there is no overlap for many in my data.
Thanks for your help!
If you want to see all the records that contain either the key words in A2:A4 or the key words in B2:B4 then you could set up an advanced filter as described in this article, especially in the section "AND vs OR".
An advanced filter has been applied to the attached copy of the file.
Let us know if you have any questions.
Amazing, thank you so much!
You're Welcome and thank you for the feedback. Please take a moment to mark t he thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks