• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Missing strings

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.
 

Attachments

  • Missing Value.xlsx
    18.6 KB · Views: 6
jeyachandran
If You yesterday solved this
Why won't You same time solve missed values?
... by pressing [ Do It ]?
 

Attachments

  • Reference.xlsb
    24.3 KB · Views: 4
jeyachandran
... totally different?
Then You should verify 'Your missing values' ... I found more differences than You based one logic (eg none ,'s).
Screenshot 2020-12-08 at 16.24.44.png
Or are those (pink column) really Example missing values, then expected missing values could be something else...
 
Back
Top