Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

removing duplicates

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Removing duplicates

Removing duplicates

ResolvedVersion 2016

Tegan has attended:
Excel Intermediate course

Removing duplicates

In my work I deal with large datasets of media coverage data where I want to remove duplicates. But what counts as a duplicate is only when an article with the same title appears on the same publication more than once - so in those two columns not just one column. If I use the remove duplicates button I'm worried it will remove data I need, i.e. rows which have the same title in different publications (which happens a lot). The trainer said there is a way to remove duplicates in this way but it's complicated.
For example:
Column A = title
Column B = Publication

How can I remove rows if both rows have the same value in column A and B?

RE: Removing duplicates

Hi Tegan,

Thank you for the forum question.

Click inside your data. On the Data tab click Remove Duplicates. In the Remove Duplicates dialog box click Unselect All and tick the two first columns and click OK.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 31 Aug 2018: Automatically marked as resolved.

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.