Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » M2T (model-to-text transformation) » How to Remove Duplicates Using Advance Filter?
How to Remove Duplicates Using Advance Filter? [message #1624971] Fri, 20 February 2015 04:26
Gangyada Krishna is currently offline Gangyada KrishnaFriend
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.
Previous Topic:Acceleo online: edit templates in the browser
Next Topic:[Acceleo] Removing duplicate in collection
Goto Forum:

Current Time: Thu Dec 07 02:35:51 GMT 2023

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

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

Back to the top