Excel Tips No 17 : Remove Duplicate Data in Your Spreadsheet

This free microsoft excel tips no 17 is telling to Remove Duplicate Data in Your Spreadsheet. Sometimes we receive a big Data, but if we check the data, actualy it's contain a lot of repetitive data. So in some case we need to remove the duplicate Data. Here is the simple step to do this.



1. Block Cell Area that will be cleaned from duplicate data
2. Click Data
3. Click Remove Duplicates
4. Done

May This Tips can be useful for You