Index and dependent dropdown list

Hi guys, I started a thread with similar request. The thread is closed but I need to make additional changes. Here is a link to the original request.
https://www.excelforum.com/excel-for...-criteria.html
John and Siva helped me with first thread, so big thanks to them.
I also posted something similar on another forum but I didn’t get answer, so I am back here and I hope you guys help me out.
So, here we go:
I have a table of products and equipment. Each cell where a product is made on a given equipment is marked “Y” or “‡”. I need your help with 3 formulas:
In column FS: find the name of the product with highest MDD (row 12) and lowest batch size (row 10)
In column FT: how many products are made on a given equipment (excluding duplicate names in E3:FQ3)
I tried COUNTIF(F13:FQ13,"Y")but it is counting everything including duplicate product names. I have duplicate product names because they are made in two sizes.
In the Calculations sheet, I need to create a drop down list dependent on the equipment list in B1 list. So if I select equipment from the first list, the second list should show only those products made on the selected equipment (Again excluding duplicate names).

The worksheet is attached.