Hi,
I have three large worksheets containing data from three different tools. The tools are used to manage equipment lists. And the list keeps changing everyday with both additions / deletions.
Worksheet 1 has about 1.3 mn rows, Worksheet 2 has 1.6 mn rows and lastly Worksheet 3 has ~ 650 K records.
All the files have multiple columns but I am interested in comparing the only the first two columns which are Asset Tag and Serial Number. I need to know the number of equipments available in all the three lists first by Tag # and from the balance list, need to know how many match by Serial #.
while I can do this by vlookup / match+index, it would be time consuming and moreover WS1 and WS2 data go beyond the excel limitation of ~1.1 mn rows.
is there a workaround / different way to do this ?
I have three large worksheets containing data from three different tools. The tools are used to manage equipment lists. And the list keeps changing everyday with both additions / deletions.
Worksheet 1 has about 1.3 mn rows, Worksheet 2 has 1.6 mn rows and lastly Worksheet 3 has ~ 650 K records.
All the files have multiple columns but I am interested in comparing the only the first two columns which are Asset Tag and Serial Number. I need to know the number of equipments available in all the three lists first by Tag # and from the balance list, need to know how many match by Serial #.
while I can do this by vlookup / match+index, it would be time consuming and moreover WS1 and WS2 data go beyond the excel limitation of ~1.1 mn rows.
is there a workaround / different way to do this ?