University of Oxford
Browse

Data tips: removing duplicate rows in Excel

Download (189.95 MB)
media
posted on 2024-11-19, 09:40 authored by SDS AdminSDS Admin
<p dir="ltr">In this self-help video, you will learn:</p><ul><li>how to use Microsoft Excel's built-in <b>Remove duplicates </b>function to identify and delete rows with duplicated data.</li></ul><p dir="ltr">This tutorial uses demonstration data from the fictitious project, <i>The Letters of Bilbo Baggins: A Critical Digital Edition</i>.</p><p dir="ltr">Methods shown here were tested in 2019 versions of Excel, on both Windows and Mac.</p><p dir="ltr"><b>Links</b></p><ul><li><a href="https://www.sds.ox.ac.uk/" rel="noreferrer" target="_blank">The Sustainable Digital Scholarship service</a></li><li><a href="https://www.it.ox.ac.uk/it-training" rel="noreferrer" target="_blank">Training courses at IT Services</a></li></ul><p></p>

History

Usage metrics

    SDS self-help library

    Licence

    Exports

    RefWorks
    BibTeX
    Ref. manager
    Endnote
    DataCite
    NLM
    DC