Find Unique value

[rajeshqvd]

Hi All,

Is it possible below Output. Required output is Required logic need to Find Single value and Assign a flag 1 and 0.

Data	A3&";"&B2	Required Output
Apple
Apple	Apple;	1
Orange	Orange;Apple;	1
Orange	Orange ;Orange;Apple;	0
Orange	Orange;Orange ;Orange;Apple;	0
Orange	Orange;Orange;Orange ;Orange;Apple;	0
Banana	Banana;Orange;Orange;Orange ;Orange;Apple;	1
Banana	Banana;Banana;Orange;Orange;Orange ;Orange;Apple;	0

In Above table Find Single value and assign 1 flag like 2nd row Apple. Thanks In Advance.