Excel: Fast way to Identify Duplicates (Huge data set)

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.

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of March 27, 2017.

For more resources for Microsoft Excel