compare column a to b and b to a

[ayazgreat]

You are welcome Ayaz. Thanks for the feedback

@Ayaz Please share this forum among your friends

Yes kris I must share it among my friends,
Now problem is that When I ran your code to compare 800,000 rows in each column , excel hangs , ok then I give 200,000 rows data then excel hangs again ? should there be limit in your code to hold data ?