Excel for comparing two columns exceeding 1,048,576 count

[Ejire]

I have an Excel macro which works well in comparing two columns A an
B.
it populates column C with unique values in A and not in B, populate
column D with unique values in column B and not in A and puts the value
found in both A and B in the fifth column (E).
Data in the columns A and B of Sheet 1 has exceeded 1,048,576 (th
maximum allowable in Excel 2007) and i will copy the overflow data i
Sheet 2's column A and B and i will like the comparison to continue i
the next worksheet.
I need the macro to treat the second worksheet as a continuation of th
first sheet and not as a separate data.
(The values i am comparing have exceeded 1million)
Kindly assist with the modification on the attached macro that wil
perform this

+-------------------------------------------------------------------
|Filename: Compare two columns.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=487
+-------------------------------------------------------------------

 

[pascal baro]

You should think about using Access for this, you're pushing Excel beyond visible limits...

 

[thompson759]

I have an Excel macro which works well in comparing two columns A and

B.

it populates column C with unique values in A and not in B, populates

column D with unique values in column B and not in A and puts the values

found in both A and B in the fifth column (E).

Data in the columns A and B of Sheet 1 has exceeded 1,048,576 (the

maximum allowable in Excel 2007) and i will copy the overflow data in

Sheet 2's column A and B and i will like the comparison to continue in

the next worksheet.

I need the macro to treat the second worksheet as a continuation of the

first sheet and not as a separate data.

(The values i am comparing have exceeded 1million)

Kindly assist with the modification on the attached macro that will

perform this.





+-------------------------------------------------------------------+

|Filename: Compare two columns.txt |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=487|

+-------------------------------------------------------------------+

I agree with pascal in that Access is far better suited for this than Excel, however, Excel can do it.
Create a second range defined on the second worksheet. After the process finishes with the first range, it then steps through the second range.

M

 

[Aviad Har-Tal]

Do you think that excel eork fast with 130000 row * 30 columns ?