This is a short blog regarding removing duplicates in excel 2010. lets make up an example.
insert following numbers into a column as in this picture
okay, now go to the ribbon control, move to the Data tab, there you will find an icon of Remove Duplicates
see below image for reference.
click Remove Duplicates button, and following image will appear
click OK, and the duplicate records are removed. you will get acknowledgement as follows