Need Help? Chat with us

Remove Duplicates from a list

In Microsoft Office Excel 2007, you have several ways to filter for unique values or remove duplicate values:



Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

To filter for unique values, use the Advanced command in the Sort & Filter group on the Data tab.






To remove duplicate values, use the Remove Duplicates command in the Data Tools group on the Data tab.

To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.




Learn 100+ Excel Tips & Tricks

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

“To be an Excel Superstar”



Download ebook