I have a large excel macro enabled document with multiple tabs. I am trying to sort a very large list (8 columns, 50,000 rows) by using condition 'must contain word' 'must not contain word' to reduce the size of the list at Column A. Column A contains whole sentences.
I am constrained with this document as it is a Word document so I cannot install/download a Macro tool e.g. Kutools for instance. I can only work with Excel's VBA code, Excel's filter options or Excel's formula options.
I cannot use Excel's Custom Autofilter as this only allows 2 conditions and I need at least 8 separate conditions.
Is there a way of using Excel's Custom Autofilter for 8 separate conditions for example 'must contain word book', 'must contain hat', etc.? bearing in mind that these conditions have to draw out a single word from a sentence.
Thanks
Bookmarks