Skip to main content



      Home
Home » Modeling » M2T (model-to-text transformation) » How to Remove Duplicates Using Advance Filter?
How to Remove Duplicates Using Advance Filter? [message #1624971] Thu, 19 February 2015 23:26
Eclipse UserFriend
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.
Previous Topic:Acceleo online: edit templates in the browser
Next Topic:[Acceleo] Removing duplicate in collection
Goto Forum:
  


Current Time: Sun Jul 06 16:20:28 EDT 2025

Powered by FUDForum. Page generated in 0.10808 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top