Is there a way (beside writing a macro) to delete if you have identical entries in a column and you want to keep only one copy of that row. For e.g.

A B C
1 2 3
1 4 5

Since there are Two 1's in A i only want to keep one copy of that row.

Thanks in advace for help,