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