you can also use the advanced filter to automatically just show you the
unique records. it's under Data, Filter, Advanced filter. Highlight which
column you want to filter for unique records. Click the Unique records only
box to filter the duplicates then either paste the new set of data on the
same column or in a new column. I suggest you paste it on a new location so
you can verify if it really worked.