filter out duplicate records with 0 instance

Next solution - using FILTER-function (Office 365) and defined table (insert table > named tblData).

=FILTER(tblData;MINIFS(tblData[Inventory];tblData[Stye];tblData[Stye])<>0)

MINIFS(tblData[Inventory];tblData[Stye];tblData[Stye]) acts like a helper column to tblData that returns per each row the min-value of the according Stye - which then can be used for the main filter

You can do this using Conditional Formatting in Excel. Assuming that the columns "Style" & "Inventory" are in column A & B respectively in your excel, you need to apply the following conditional formatting on entire column A

=COUNTIFS($A:$A,$A1,$B:$B,0)>0

This will highlight all the cells that match the above condition. Then you can use "Filter by color" feature in excel.