Deleting duplicate records

There are several ways to do this.

Assuming that your data is in column A....

Type the following formula into B1

=COUNTIF(A:A,A1)

and copy this down to the other cells in column B adjacent to your data.

If a value is replicated, the number returned by the formula will be greater than 1. Using autofilters will allow you to quickly identify the rows which appear multiple times.

Another way is to sort the data by column A and use the EXACT function to test if two adjacent rows are identical.

Type =EXACT(A1,A2) into B1

You will get a value of TRUE if adjacent rows are identical.