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).
Use the filter condition 'contains substring' and 'Text ends with' on product column to get desired output.
for solution click here