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