Removing duplicated data in excel is made easy with Remove Duplicate button found in the Data Tab.

via How to remove duplicates in Excel — Computer Training Courses SYDNEY