VBA Missing strings

[jeyachandran]

Dear sir,
I need a macro to compare two column values (B & C) and extract missing values and to be populate in column C. the macro to be compare each string from
column C to B and extract the result in column D. Example missing values shown in column F for your reference.

Could you help me to resolve my issue?


Note:
* compare each text and numbers and alpha numeric numbers
* compare Special Characters like # @ , : ; /. ( ) _ " ' etc also
* compare from 2 to last row.

 

[vletm]

jeyachandran
If You yesterday solved this

VBA Concatenate

Hi guys, I have to Concatenate columns values from C to CD (only filled values), the format should be shown in example file, so i need to Concatenate the cell value like that in (column B), so i need to automate using vba, so please anyone help me to resolve my...

chandoo.org

Why won't You same time solve missed values?
... by pressing [ Do It ]?

 

[jeyachandran]

Hi sir,
Missing Value.xlsx file is totally different from VBA concatenate, in Missing Value file only compare text and numbers from one column to
another column and extract the result. so that i explained in text. so please update your comments.

 

[vletm]

jeyachandran
... totally different?
Then You should verify 'Your missing values' ... I found more differences than You based one logic (eg none ,'s).

Or are those (pink column) really Example missing values, then expected missing values could be something else...

 

[jeyachandran]

Expected missing values sir. those values are extracted from software, but i need a macro to compare and extract missing..

 

[vletm]

jeyachandran
I gave to possible answers ... did I get clear answer?
Should I continue guessing?
I need a clear answer - what?