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

In this self-help video, you will learn:

  • how to use Microsoft Excel's built-in Remove duplicates function to identify and delete rows with duplicated data.

This tutorial uses demonstration data from the fictitious project, The Letters of Bilbo Baggins: A Critical Digital Edition.

Methods shown here were tested in 2019 versions of Excel, on both Windows and Mac.

Links

History

Usage metrics

    SDS self-help library

    Licence

    Exports

    RefWorks
    BibTeX
    Ref. manager
    Endnote
    DataCite
    NLM
    DC