How the repetitions are removed in the column of excel sheet?

In my view I would remove duplicate entries in following way (considered that Microsoft Excel2007 is in use)1) select the entire column which contains duplicate entries2) go to data, then click on remove duplicates.
This way I would remove duplicates

The method I use depends on the data set, but is you are working with a single column, I remove the repetitions in a few simple steps.1.
Sort de data set (A Column in this example) and add a title in A12.
Add in the neighbouring column a title in B1, and in B2 the formula "IF(A1=A2;"X";"")3.
Copy this formula down until the end of the data set.
All repetitions are now marked with a "X"4.
Copy column B and paste it on same spot back as values.5.
Sort the dataset (A) with the marker column (B), so that all X-es are grouped.6.
Delete all marked records.
This way you can clean up1000's of records in seconds.

Hi Abdur, its very easy. Follow the steps for Excel2007 and above :-

 

1. Select the column or cells where you want the duplicates to be removed

2. Goto DATA tab and under Data tools you will find Remove Duplicates

3. Click Remove Duplicates and VOILA !!! the duplicates/repetitions are gone

Enjoy :)