Hi,
I have data base as below
And would like to get result following last column as below. Could you pls support if any Excel formula works in this case?
I have data base as below
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | OrderNumber | ColorDescription | Approval date | ||
2 | 4701740244 | Multi | 1-Jan | ||
3 | 4701740244,4701740244 | Yellow,Blue | 3-Jan | ||
Sheet1 |
And would like to get result following last column as below. Could you pls support if any Excel formula works in this case?
Book1 | |||||
---|---|---|---|---|---|
F | G | H | |||
1 | OrderNumber | ColorDescription | Approval date - result s/b | ||
2 | 4701740244 | Blue | 3-Jan | ||
3 | 4701740244 | Yellow | 3-Jan | ||
4 | 4701740244 | Multi | 1-Jan | ||
Sheet1 |