Hi guys,
I need your help with this table, where I need to identify the highest risk product made on a given equipment based on risk score number.
As shown in the table, there different products made on each equipment and those cells are marked "Y". Each column with Y's contain a risk score in the bottom of the table. However, there might be two products having highest risk score like in row 7 where there are 2 products having risk score of 90. In this case, the formula should select the product with largest batch size (row 6).
The work sheet is attached. Thanks in advance.
Risk score.jpg
Bookmarks