Hello!
I tried to find a solution to my question in exiting threads, but none of them exactly do what I want. The closest to what I need is this thread: VBA to Compare Columns, but for some reason, the solution there does not work in my case.
I have two columns A and B with names. They have different number of entries, but both over a 1000. I want in column D to list all the names which are present in column A, but absent from column B. In column E, I want to list all the names which are present in column B, but absent from column A. The lists in columns A and B should remain as is.
Thank you!
I tried to find a solution to my question in exiting threads, but none of them exactly do what I want. The closest to what I need is this thread: VBA to Compare Columns, but for some reason, the solution there does not work in my case.
I have two columns A and B with names. They have different number of entries, but both over a 1000. I want in column D to list all the names which are present in column A, but absent from column B. In column E, I want to list all the names which are present in column B, but absent from column A. The lists in columns A and B should remain as is.
Thank you!