Contains Substring

Input: Sample file with base data.

Download sample input files here

Goal: Setup a workbook formula that pulls the data from the sample file and apply a filter to get all the Product having substring DEMAND only. (should not contain word similar to DEMANDED,DEMANDING).

Hint:

Use the filter condition 'contains substring' and 'Text ends with' on product column to get desired output.

for solution click here