In a separate column I would like to answer "Yes" or "No" if there is a value greater than zero somewhere in the same row if that number falls under the column header that matches a predefined list. It can be more than one number meeting this criteria, but it has to be at least one in the row.
<tbody>
</tbody>
Predefined List
Nuts
Pear
Banana
Also is it possible to have the formula allow for expanding predefined list.
Thank you.
Unit No | SOP | apple | pear | oranges | nuts | banana |
45 | Yes | 3 | 9 | 5 | 7 | |
88 | Yes | 2 | 8 | 1 | ||
12 | No | |||||
7 | Yes | 3 |
<tbody>
</tbody>
Predefined List
Nuts
Pear
Banana
Also is it possible to have the formula allow for expanding predefined list.
Thank you.