Hi all,
Please help me to fix this
I have a problem. I want to put a formula in Column B which is "True" If Column A have same word in Column E within the column.
Sample
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]Fc Hoechst[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Al Hidd[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]Dinamo Minsk[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]The Balloon Place
[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]100 Ball Court[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Fc Innsbruck Union[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]ABC Jack Street[/TD]
[TD]True[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 300"]
<tbody>[TR]
[TD]Column E[/TD]
[/TR]
[TR]
[TD]Minsk Shoot[/TD]
[/TR]
[TR]
[TD]Food Court[/TD]
[/TR]
[TR]
[TD]Hoechst Way[/TD]
[/TR]
[TR]
[TD]Qalili[/TD]
[/TR]
[TR]
[TD]Fc Stated Innsbruck[/TD]
[/TR]
[TR]
[TD]The Balloon Place[/TD]
[/TR]
[TR]
[TD]Street Food[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table"]
<tbody></tbody>[/TABLE]
Pls. help me I'll do a report for this.
Thanks & Regards,
Roy
Please help me to fix this
I have a problem. I want to put a formula in Column B which is "True" If Column A have same word in Column E within the column.
Sample
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[/TR]
[TR]
[TD]Fc Hoechst[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Al Hidd[/TD]
[TD]False[/TD]
[/TR]
[TR]
[TD]Dinamo Minsk[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]The Balloon Place
[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]100 Ball Court[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]Fc Innsbruck Union[/TD]
[TD]True[/TD]
[/TR]
[TR]
[TD]ABC Jack Street[/TD]
[TD]True[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 300"]
<tbody>[TR]
[TD]Column E[/TD]
[/TR]
[TR]
[TD]Minsk Shoot[/TD]
[/TR]
[TR]
[TD]Food Court[/TD]
[/TR]
[TR]
[TD]Hoechst Way[/TD]
[/TR]
[TR]
[TD]Qalili[/TD]
[/TR]
[TR]
[TD]Fc Stated Innsbruck[/TD]
[/TR]
[TR]
[TD]The Balloon Place[/TD]
[/TR]
[TR]
[TD]Street Food[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table"]
<tbody></tbody>[/TABLE]
Pls. help me I'll do a report for this.
Thanks & Regards,
Roy