compare column a to b and b to a

[ayazgreat]

Hi
I have 800,000 rows data in column a and near about same data in column b, actually I was using vlookup formula to comprare both columns data but it hangs workbook and does not work.
I want a macro to find colomn b value in col a ad copy those values are not found in column a i mean unique values from.col b which are not matched in col a.
And same procedure for column a values to find in col b and copy those values are not found in col b.




https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA