topic Re: Shared drive duplicate file? in Peer-Peer Topics

Shared drive duplicate file?

jasoncrcsd — Tue, 19 Mar 2024 14:30:33 GMT

Is there any way or app of searching for duplicate files in a shared/team drive? I have a departments drive that hit the 400k limit. I've found a few for your personel drive but they don't work on a shared drive and I'm sure they probably have many duplicates but the best I could find was the GAM print command but a sheet with 400k rows is a bit much to go through

Re: Shared drive duplicate file?

Kim_Nilsson — Tue, 19 Mar 2024 14:34:10 GMT

Well, using the duplicate row feature in Sheets should be possible, but sadly it works the wrong way.

We don't want to remove the duplicates from the file, we want to surface them.

Of course, there's a workaround for that. 🙂

Keep a copy of the original list, and after you let Sheets remove duplicates, you compare the two lists (VLOOKUP works), and it'll show you which files are dupes.