the easiest way is to use sorting a filtering functions of excel.
to do this
1. frst click any cell in worksheet, then press "ctrl" and "a" at same time on keyboard to select all cells
2. then click the "data" tab
3. click "remove duplicates" in the banner that appears after clicking the tab
4. in the remove duplicates window, select only those column or columns that contain duplicates. (if you select too many columns it wont work and you will have to try it again with less columns)
5. click ok, you will see a message telling you how many duplicates have been removed. If you selected 1 column, in step 4 and have tried each one separately and you get a message saying no duplicates, then that means that all duplicates have been removed.
in the future to avoid any confusion or delayed reposes, you may want to work with a single expert for your Excel issues. I would be happy to help in that regard.
feel free to ask for me again in the future if I can be of any more assistance, http://www.justanswer.com/computer/expert-1expert-2rulethemall/