MarkCBB
Active Member
- Joined
- Apr 12, 2010
- Messages
- 497
Hi there,
I have 100,000,000 (One hundred Million) Alphanumeric Codes, (100 columns with 1 Million in each column).
I have tried to use worksheetfunction.coutif(range,cell.value) > 1 but this take about 3-4 seconds per cell, thus over 5-6 years to calculate.
Does anyone have ideas on how to do this efficiently? like under 24 hours.
I have 100,000,000 (One hundred Million) Alphanumeric Codes, (100 columns with 1 Million in each column).
I have tried to use worksheetfunction.coutif(range,cell.value) > 1 but this take about 3-4 seconds per cell, thus over 5-6 years to calculate.
Does anyone have ideas on how to do this efficiently? like under 24 hours.