More that two Duplicates

General discussion related to "Everything".
Post Reply
Whirly
Posts: 9
Joined: Fri Feb 24, 2017 6:51 pm

More that two Duplicates

Post by Whirly »

The duplicate search is great. I'm just wondering if there is a way to limit the results to items with more than a specified number of duplicates.

Also given this: viewtopic.php?f=5&t=5313&p=14042&hilit= ... ize#p14040
"""""""""""Think of dupe: and sizedupe: in Everything as:
duplicated file names in the entire index and duplicated sizes in the entire index.

finding duplicated names in a list of duplicated sizes (or duplicated sizes in a list of duplicates names) is a two pass search, which Everything is not designed to do.
""""""""""""""""""""""""
and viewtopic.php?f=5&t=5696&p=15683&hilit= ... ize#p15683

I guess one could run dupe: and then export a .csv, and then filter the results for size and date modified. In Excel maybe use COUNTIF().

Any other suggestions for Excel? I'll search Excel forums, but just checking in case someone has experience with this approach.

Oh, I could use something in Excel for finding more than 2 duplicates also.
NotNull
Posts: 5458
Joined: Wed May 24, 2017 9:22 pm

Re: More that two Duplicates

Post by NotNull »

In Excel, use a pivot table (row=filename; data=count filename)
Not tested, but should work.
After that, you can sort and filter the pivot table.
Post Reply