VBA Matching Data Output Matched results

Hello All,

I am certainly not the most proficient at VBA and have (what i think!) is a relatively simple need.

Column A - This contains a list of e-mail addresess
Column B - This also contains a list of e-mail addresses.

I am looking to output into column C all the matched e-mail address's without any duplicates. The end goal being that there is a complete third list with e-mail addresses unique e-mail address's based on them being contained in both column A and column B. For Example

Column A	Column B	Column C
Email1attest	Email2attest	Email1attest
Email3attest	Email1attest	Email2attest
Email2attest	Email4attest
Email5attest	Email4attest
Email5attest	Email4attest
Email1attest	Email2attest

I wrote something but found a better snippet online that doesnt do quite what i want to do. it highlights matched data rather than outputs. Whatever i try to do to get this to output into column C i cant seem to get it to work.

Please Login or Register  to view this content.

Any help would be really appreciated

Are you capable of adapting the code from this thread to your needs ?
https://www.excelforum.com/excel-new...ate-match.html