Shared drive duplicate file?

[jasoncrcsd]

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

[Kim_Nilsson · Accepted solution]

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.