How to Remove Duplicates Using Advance Filter? [message #1624971] |
Fri, 20 February 2015 04:26 |
Gangyada Krishna Messages: 2 Registered: February 2015 |
Junior Member |
|
|
How to Remove Duplicates Using Advance Filter?
Removing duplicates is one of the important tasks, when we work with database in excel. Many times you encounter a situation where you need to remove duplicate records/data. In the following article we tried explaining you 'How to remove duplicates using Advanced Filter', hope this articles helps you!
1 Data before removing duplicates.
2 Data after removing duplicates.
Let us follow step by step process for removing duplicates using Advanced Filter.
1 Select a cell in your data set and choose Data from menu.
2 Select Filter and select Advanced from Sort and Filter group.
3 Advanced Filter dialogue box appears.
4 Enter the range of data containing duplicates in the box provided for List range.
Here the List range is '$B$3:$C$16'.
5 Check the box Unique Records Only and click OK.
|
|
|
Powered by
FUDForum. Page generated in 0.02026 seconds