have 600,000 rows of data. I would like to find how many duplicates are
there in this 3 coulmn of 600,000 rows of data. I would like to use Pivot
Table to do that. However, each column can contain only about 60,000 rows.

Can anyone help to find how to find how many duplicate data?