Data tips: removing duplicate rows in Excel
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
Licence
Exports
RefWorksRefWorks
BibTeXBibTeX
Ref. managerRef. manager
EndnoteEndnote
DataCiteDataCite
NLMNLM
DCDC