VBA Macro for string check

[bizzarofen]

Hello, I would like to create a macro, which will will check whether the country in col B is different from country in column C and provide for instance 1 in col D in case of condition being true, based on the format below:
1234567890.PNG
I'd appreciate some help. Thanks.

[:) Sixthsense :)]

In D2 cell

Please Login or Register  to view this content.

Drag the above formula down.

[bizzarofen]

Hello Sixthsense , many thanks for your support, however I am afraid that formula is not working as I have the following output (that's only 1 example):
66666.PNG
In column C there is Mauritius, which is different than India in col B, so it should be treated as a match.

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[bizzarofen]

Please find the spreadsheet attached. I have put the desired output in col D - for each country in col C, which is different from col B there will be 1.

[mikerickson]

You have a variety of white space characters at the end of the column C values.

This formula should do what you want
=SIGN(LEN(SUBSTITUTE(CLEAN(UPPER(C2))&";",UPPER(CLEAN(B2))&";","")))

[bizzarofen]

Thank you mikerickson, it's precisely what I have been looking for.

[mjr veverka]

You have a variety of white space characters at the end of the column C values

Yes it's true, and the macros didn't work out correctly, but you can "bizzarofen" also in that way with macro