microsoft is a wonderful office tool for all type of data related operations. Lot of data options are available. For remove a particular column data duplicates use the following method.
1. select the column
2.Press on data tab of microsoft excel
3.Can see a command “remove dupliactes”.
Also we can use advanced command in the filter and sort group on the Data tab.
For highlighting duplicate or unique data values the conditional formatting command in home tab can use.