Hi fellow excel users, I want to filter a list of materials based on search criteria i.e. (materials containing text string *moto* and exclude 03 text strings *wire*, *shaft* & *bear*). I would really appreciate help from you guys.
Hi fellow excel users, I want to filter a list of materials based on search criteria i.e. (materials containing text string *moto* and exclude 03 text strings *wire*, *shaft* & *bear*). I would really appreciate help from you guys.
Please add the expected result manualy in the file and post the excel file again.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Dear Oeldere,
Please find attached workbook with expected output.
I filter on cel B5 on motor and get this list.
It is not the same as your expected result.
What are the differant criteria?
See the attached file.
Filter criteria is (materials should contain text string *moto* and does not contain text strings *wire*, *shaft* & *bear*) Highlighted materials in resulted output are missing from your filtered data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks