Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel for comparing two columns exceeding 1,048,576 count
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel for comparing two columns exceeding 1,048,576 count
You should think about using Access for this, you're pushing Excel beyond visible limits...
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel for comparing two columns exceeding 1,048,576 count
On Sunday, July 22, 2012 12:13:01 PM UTC-4, Ejire wrote:
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| +-------------------------------------------------------------------+ -- Ejire 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel for comparing two columns exceeding 1,048,576 count
On Friday, July 27, 2012 10:59:44 PM UTC+3, wrote:
On Sunday, July 22, 2012 12:13:01 PM UTC-4, Ejire wrote: 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| +-------------------------------------------------------------------+ -- Ejire 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 Do you think that excel eork fast with 130000 row * 30 columns ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count if with and comparing three columns | Excel Worksheet Functions | |||
Count number of values until exceeding a figure | Excel Worksheet Functions | |||
exceeding columns limit | Excel Discussion (Misc queries) | |||
Excel csv spreadsheet-How to save info exceeding 20 columns | Excel Worksheet Functions | |||
"Text to Column" - exceeding maximum number of columns possible | Excel Programming |