HI Guys,
I have this file with me with about 25k products and I have to categorize them based on their name, so the best way to do so is filter them based on values and give all the same category name, however if I use terms I get values that are not required and i would Like to exclude those from the result set.
I wanted to know if its possible to filter values based on one column has "Include" and remove the results that contain matches from the values in the second column " Exclude" and this should be realtime, like when I type in a word and I hit enter it should filter or some button i can click that will rerun the filters.
I've attached a file and a sample search, show all results that have "fish" but dont show those that have book,guide, charts, in this example there are only 2 columns to be filtered, title & description. The filter should be done on the Title column and that will be constant.
any ideas on how I can do this? with some form? or something that can just use two columns to filter data?
Any help is really appreciated guys, I have 200k file to work on next and this could really make my work easier, I've always loved the help and love giving out reputation and shoutouts!
Thanks
Alfred
Bookmarks