Quicker than manually looking for the duplicate rows in Excel, highlight the new column, copy it to the clipboard and then without changing the activated cells do edit > paste special > values to fix it all as text. Sort again by that column and all your duplicates will be together. Steve.