hi,
[TABLE="width: 458"]
<colgroup><col span="2"><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Charge[/TD]
[TD]Currency[/TD]
[TD]Collector[/TD]
[TD][/TD]
[TD="colspan: 3"]Correct Data[/TD]
[/TR]
[TR]
[TD]XNG[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD]XNG[/TD]
[TD]BRL[/TD]
[TD]LIBRAN8[/TD]
[/TR]
[TR]
[TD]XNG[/TD]
[TD]USD[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD]THD[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[/TR]
[TR]
[TD]XNG[/TD]
[TD]BRL[/TD]
[TD]LIBRAN7[/TD]
[TD][/TD]
[TD]THD[/TD]
[TD]USD[/TD]
[TD]LIBRAN7[/TD]
[/TR]
[TR]
[TD]XNG[/TD]
[TD]BRL[/TD]
[TD]LIBRAN8[/TD]
[TD][/TD]
[TD]DDF[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[/TR]
[TR]
[TD]THD[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THD[/TD]
[TD]BRL[/TD]
[TD]LIBRAN7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THD[/TD]
[TD]USD[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THD[/TD]
[TD]USD[/TD]
[TD]LIBRAN7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DDF[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DDF[/TD]
[TD]BRL[/TD]
[TD]LIBRAN6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
This is a excel format.
right side data is correct data ok, i need to compare and show output.
if XNG=BRL=LIBRAN8 means need to show near column as "No Error".
else show near column as "Error"
This can be done whole column and right side data is correct data.
Please create and send me a excel macro code.
[TABLE="width: 458"]
<colgroup><col span="2"><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Charge[/TD]
[TD]Currency[/TD]
[TD]Collector[/TD]
[TD][/TD]
[TD="colspan: 3"]Correct Data[/TD]
[/TR]
[TR]
[TD]XNG[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD]XNG[/TD]
[TD]BRL[/TD]
[TD]LIBRAN8[/TD]
[/TR]
[TR]
[TD]XNG[/TD]
[TD]USD[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD]THD[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[/TR]
[TR]
[TD]XNG[/TD]
[TD]BRL[/TD]
[TD]LIBRAN7[/TD]
[TD][/TD]
[TD]THD[/TD]
[TD]USD[/TD]
[TD]LIBRAN7[/TD]
[/TR]
[TR]
[TD]XNG[/TD]
[TD]BRL[/TD]
[TD]LIBRAN8[/TD]
[TD][/TD]
[TD]DDF[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[/TR]
[TR]
[TD]THD[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THD[/TD]
[TD]BRL[/TD]
[TD]LIBRAN7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THD[/TD]
[TD]USD[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]THD[/TD]
[TD]USD[/TD]
[TD]LIBRAN7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DDF[/TD]
[TD]BRL[/TD]
[TD]LIBRAN10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DDF[/TD]
[TD]BRL[/TD]
[TD]LIBRAN6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
This is a excel format.
right side data is correct data ok, i need to compare and show output.
if XNG=BRL=LIBRAN8 means need to show near column as "No Error".
else show near column as "Error"
This can be done whole column and right side data is correct data.
Please create and send me a excel macro code.