Do you know, that… ?
W SOLIDWORKS 2023 there was the possibility of advanced search in the BOM list of materials.
In order to search in a given column, press the symbol as below and specify the search phrase.
You can use custom filters and define conditional advanced selection criteria.