Excel - How to remove duplicates entries from a column
Here's a simple method to remove duplicates entries from a column:
- Click on the Data menu.
- Advanced Filter.
- In the List Range field, select the column where the duplicates are.
- Check "Unique record only" and click on OK.
Published by jak58
Latest update on October 16, 2014 at 07:21 AM by deri58.