Hi,
Please help me, how to make a formula if two cells have multiple words and if they have same word will become true.
Example.
I want in Column C will "True" if Column A & B have same word.
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]Fc Innsbruck Union[/TD]
[TD]Fc Stated Innsbruck[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Fc Hoechst[/TD]
[TD]Blau Hoechst Feldkirch[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Al Hidd[/TD]
[TD]Qalali[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]Dinamo Minsk[/TD]
[TD]Minsk Mozyr[/TD]
[TD]True[/TD]
[/TR]
</tbody>[/TABLE]
Thank you & Regards,
Roy
Please help me, how to make a formula if two cells have multiple words and if they have same word will become true.
Example.
I want in Column C will "True" if Column A & B have same word.
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]Fc Innsbruck Union[/TD]
[TD]Fc Stated Innsbruck[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Fc Hoechst[/TD]
[TD]Blau Hoechst Feldkirch[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Al Hidd[/TD]
[TD]Qalali[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]Dinamo Minsk[/TD]
[TD]Minsk Mozyr[/TD]
[TD]True[/TD]
[/TR]
</tbody>[/TABLE]
Thank you & Regards,
Roy