Spreadsheet: 848381d1699103432-how-to-filter-select-specific-strings-from-a-big-database-if-and-or-search-left-example-for-forum-3-nov-2023-jacc
Sheet: Forum (3)

 |  |  |  |  |  |  |  |  |  | How can I adapt the formula to only exclude strings that start with "Method", "A method", "The Method"? |  | https://www.excelforum.com/excel-formulas-and-functions/1414659-how-to-filter-select-specific-strings-from-a-big-database-if-and-or-search-left.html
Some examples for strings that occur in the big data sheet (80 columns; 900 rows) |  |  |  | Two attemps from myself (but not succesful yet) |  |  |  |  |  | Method |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  | A method
Attempt 1 |  |  |  |  |  |  |  |  |  | The Method
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False | True | True | False
 |  |  |  |  |  |  |  |  |  |  |  |  | False | False | True | True | True | True | False | False | False | False | False | False | False | False | False
 |  |  |  |  |  |  |  |  |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False | False | False | False | True
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | Apparatus for controlling something different | -
 |  |  |  |  |  |  |  |  |  | - | - | -
 |  |  |  |  |  |  |  |  |  | A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
 |  |  |  |  |  |  |  |  |  | An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
 |  |  |  |  |  |  |  |  |  | - | - | -
 |  |  |  |  |  |  |  |  |  | Complete formula
 |  |  |  |  |  |  |  |  |  |  | Apparatus for controlling something different | -
 |  |  |  |  |  |  |  |  |  | - | - | -
 |  |  |  |  |  |  |  |  |  | A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
 |  |  |  |  |  |  |  |  |  | An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
 |  |  |  |  |  |  |  |  |  | - | - | -