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

[Excel Fox]

Ayaz, are you sure all of these records are unique if we were to look at both the columns together, or will there be duplicates at that level too?

[ayazgreat]

There are duplicated values also , most of records are duplicated but I want to compare both columns to see that which records are unique if these are in col a or b

[ayazgreat]

An example a column has values 1,3,4,6,9,11,12 and b column has values 1,2,3,7,9,10,13
When compare col b from col a so result is 2,7,10,13
When compare col a to col b so result is 4,6,11,12

[Rick Rothstein]

An example a column has values 1,3,4,6,9,11,12 and b column has values 1,2,3,7,9,10,13
When compare col b from col a so result is 2,7,10,13
When compare col a to col b so result is 4,6,11,12

Are these examples of real values you have? If so, what is the maximum value that can appear in a column? Depending on your two answers to these questions, there may be a relatively simple code solution. However, if those are values that you actually have, could you post an example with the real values? Again, depending on what they are, there again, may be a relatively simple code solution.

[ayazgreat]

Yes these are values , real.example like
Col a
814090
814091
814092
818000
818001
818002
818003
910010
987012

Col b
814090
814092
814093
814095
818003
818004
818005
818009
818010
818011
910010
910011
910012
987761

The data of both columns are in 800,000 rows of each

[Rick Rothstein]

Yes these are values , real.example like
Col a
814090
814091
..........

Col b
814090
814092
..........

The data of both columns are in 800,000 rows of each

What is the minimum and maximum possible values in each column?

[ayazgreat]

Minimum 400,000 to 500,000 and maximum 10,00,000

[ayazgreat]

Could it be possible to be done through code

[Admin]

Hi

Could you please upload a sample workbook with expected result ?