Download Excel File: https://excelisfun.net/files/EMT1653.xlsm
Learn how to extract records from a table based on Partial Text Criteria or Contains Criteria.
1. (00:01) Introduction
2. (00:01) Extracting Sales Records Based on Partial Product Name.
3. (00:27) FILTER, SEARCH and ISNUMBER Functions to extract records Based on Contains Condition. Formula Not Case-Sensitive.
4. (02:29) FILTER, FIND and ISNUMBER Functions to extract records Based on Contains Condition. Formula Is Case-Sensitive.
5. (02:59) Extract Customers on Particular Street Example.
6. (03:11) Summary and End Video Links