Eclipse Community Forums: M2T (model-to-text transformation) » How to Remove Duplicates Using Advance Filter?

Help

Home

Home » Modeling » M2T (model-to-text transformation) » How to Remove Duplicates Using Advance Filter?

Show: Today's Messages :: Show Polls :: Message Navigator

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.

Attachment: How to Remove Duplicates Using Advance Filter.pdf
(Size: 333.85KB, Downloaded 247 times)

Report message to a moderator

Previous Topic:	[Acceleo] How to log or monitor inoperable plug-in?
Next Topic:	[Xtext] updating/writing resource descriptions chunk x of xxx

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 24 20:53:55 GMT 2018

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter