Lessons › Excel & Google Sheets
Excel & Google Sheets lesson
Remove duplicates
Count everything once
Try this lesson free →Key points
Remove duplicatesDelete rows that repeat another row exactly.
Why it mattersEvery duplicate inflates totals and counts.
Then sort or filterClean first, then analyse.
Remove duplicates is in the Data menu of Excel and Google Sheets. Here, it's in the toolbar.
Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →