Ask Your Question

Find Duplicates

asked 2017-04-03 20:10:15 +0200

Cosmo1953 gravatar image

updated 2017-04-03 22:46:50 +0200

Lupp gravatar image

How do i find and delete duplicates in my spreadsheet?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-04-03 22:46:11 +0200

Lupp gravatar image

updated 2017-04-03 22:47:47 +0200

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-03 20:10:15 +0200

Seen: 13,532 times

Last updated: Apr 03 '17