Order | Appple | Orange | Lemon | None | Null | ProdType |
1 | Apple | Apple | ||||
2 | Apple | None | Null | Apple | ||
3 | Apple | Orange | Multiple | |||
4 | None | Null | No ProdType | |||
5 | Lemon | None | Null | Lemon | ||
6 | None | No ProdType | ||||
7 | Apple | Orange | Lemon | None | Null | Multiple |
8 | Null | No ProdType |
<tbody>
</tbody>
Based on the following criterias, I need a formula to get the ProdType.
Thanks for in advance.
<attachment></attachment><attachment></attachment>