Excel String Comparison Macro

[ramalvi]

hi,

Charge	Currency	Collector		Correct Data
XNG	BRL	LIBRAN10		XNG	BRL	LIBRAN8
XNG	USD	LIBRAN10		THD	BRL	LIBRAN10
XNG	BRL	LIBRAN7		THD	USD	LIBRAN7
XNG	BRL	LIBRAN8		DDF	BRL	LIBRAN10
THD	BRL	LIBRAN10
THD	BRL	LIBRAN7
THD	USD	LIBRAN10
THD	USD	LIBRAN7
DDF	BRL	LIBRAN10
DDF	BRL	LIBRAN6

<colgroup><col span="2"><col><col span="2"><col><col></colgroup><tbody>
</tbody>

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

Charge	Currency	Collector		Correct Data
XNG	BRL	LIBRAN10		XNG	BRL	LIBRAN8	No Error
XNG	USD	LIBRAN10		THD	BRL	LIBRAN10	No Error
XNG	BRL	LIBRAN7		THD	USD	LIBRAN7	No Error
XNG	BRL	LIBRAN8		DDF	BRL	LIBRAN10	No Error
THD	BRL	LIBRAN10
THD	BRL	LIBRAN7
THD	USD	LIBRAN10
THD	USD	LIBRAN7
DDF	BRL	LIBRAN10
DDF	BRL	LIBRAN6

<tbody>
</tbody>

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!