Problem with Multiple Filter

Dear All,
I am facing a problem in the excel file with multiple filter.

My problem is, As shown in the attached excel file.
In one column of the file, I have ingredients code no and selling item code number,
Ingredient code starts with 1001 to 1500
selling item starting alphabets and the whole code like sa005, am009, am023 etc.

now I want a filter which will select all the selling item code with only one ingredient, so that I can find out the total consumption of this ingredient.

Currently I select all items in the columns and then manually go and deselect all 500 ingredients and then get the output as shown in the output.

I am convinced that there has to be a better way to solve this.
Kindly assist
Thanks