Facing problem in a Macro which compares 2 columns having comma separated / single values

Hello Guys,

I am facing an error in a Macro and need your help in resolving the same.

I am using a Macro in attached file for comparing the delimited separated values between 2 columns.

In attached file I am comparing the values present in Column C and D with Column A. If Column C is containing a unique value (the value of Column A is different) then Column E will mark as 1 else 0. Same thing we do with Column D and if there is unique value then Column F will mark as 1 else 0.

Issue – The problem I am facing in a Macro is if Column C or D is not having any entry then the Macro will generate 1 in first cell of Column E or F (for example please check cell marked as yellow in attached file).

I want if there is no value in Column C or D then Macro should not generate any value in Column E or F.

Please refer the attached “Sample” Macro file.

Thanks,
MG