Hello
I need help Please, It make me confuse. Need single Formula if can. For My Situation.
Rule:
1. Only Coloum With "Good", "Bad" and "Other" Word Will Pick
2, If Theres Two or Three words in same Coloum only pick the First
3, If in One Coloum have same words will pick the First
4, If Theres no Word will fill with Blank
Let's Picture Explain this.
Excel Formula.jpg
I don't know how to put Attachment, it's not working. So I put my sample on Google Drive.
www*drive*google*com/open?id=1TZMNIEFiA9BWbG9yHIm1iMXP1K6YOFwz
Change * with . (dot)
Bookmarks