How do i find and delete duplicates in my spreadsheet?
Let’s assume there are data in columns A through C. Rows with identical contents in all these three columns are considered duplicates (or higher multiples) of one “original”.
Using ‘Data’>‘More Filters’>‘Standard Filter…’ with the settings demonstrated in the attached example will do the task.