Excel String Comparison Macro

[ramalvi]

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.

 

[Domenic]

Is a formula solution acceptable? If so, try...

A1:H11

[TABLE="width: 800"]
<tbody>[TR]
[TD="class: xl63, width: 64"]Charge[/TD]
[TD="class: xl63, width: 64"]Currency[/TD]
[TD="class: xl63, width: 64"]Collector[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"]Correct Data[/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl63"]XNG[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN10[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]XNG[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN8[/TD]
[TD="class: xl63"]No Error[/TD]
[/TR]
[TR]
[TD="class: xl63"]XNG[/TD]
[TD="class: xl63"]USD[/TD]
[TD="class: xl63"]LIBRAN10[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]THD[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN10[/TD]
[TD="class: xl63"]No Error[/TD]
[/TR]
[TR]
[TD="class: xl63"]XNG[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN7[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]THD[/TD]
[TD="class: xl63"]USD[/TD]
[TD="class: xl63"]LIBRAN7[/TD]
[TD="class: xl63"]No Error[/TD]
[/TR]
[TR]
[TD="class: xl63"]XNG[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN8[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]DDF[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN10[/TD]
[TD="class: xl63"]No Error[/TD]
[/TR]
[TR]
[TD="class: xl63"]THD[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN10[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]THD[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN7[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]THD[/TD]
[TD="class: xl63"]USD[/TD]
[TD="class: xl63"]LIBRAN10[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]THD[/TD]
[TD="class: xl63"]USD[/TD]
[TD="class: xl63"]LIBRAN7[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]DDF[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN10[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl63"]DDF[/TD]
[TD="class: xl63"]BRL[/TD]
[TD="class: xl63"]LIBRAN6[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"]


[/TD]
[/TR]
</tbody>[/TABLE]
H2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=IF(ISNUMBER(MATCH(E2&"#"&F2&"#"&G2,$A$2:$A$11&"#"&$B$2:$B$11&"#"&$C$2:$C$11,0)),"No Error","Error")

Hope this helps!