Advanced Excel Techniques Excel VBA and Macros

Duplicate Files Finder Tool

Table of Content

About the tool

Duplicate Files Finder Tool is an MS Excel based tool to identify duplicate files exist in your system or shared folder. The tool takes a base folder path as input and list down all duplicate files in the folder and sub-folders. It has capability to find duplicate files by comparing the names and their size.

Tool Features

Compare file names for duplicate after removing version numbers
Allows file size variations setting to compare files with different file sizes
Moves identified duplicate files to another folder

Benefits

Save time to identify duplicate files
Save system or shared folder space

System Requirements

You need to have installed version of MS Excel 2010 or above

Tool Limitations

As the number of files increases, tool may take more time to identify duplicates

How to use this tool

Follow the below video which details out how to use this tool.

Open the tool and you will see below screen
If the macros are disabled, click on Enable Content button
Select the base folder path from which you want to identify duplicate files
There are two settings through which you can control identifying duplicate files logic
File Size Variation Allowed: Through this setting you can control the variations allowed in file size while comparison. For example, a file named Test.doc (118 KB) and another one named Test.doc (23 KB) can be found as duplicate if the file size variation allowed is 100 KB

To change this setting, click on the dropdown and update the setting as required

Remove Characters from File Name before Matching: Through this setting you can remove version details from the file name before comparing its name. For example, a file named test v1.0 and test v2.0 may be duplicate

To change this setting, click on View Setting button

Here you can mention the characters to be removed from file name before comparison
Once you are done with the initial settings, click on Start Finding Duplicates button
Depending on number of files available for analysis, tool may take some time for analysis and identifying duplicate files. Once done, it will filter them and show you the result
If you want to move the duplicate files in another folder then select the folder where you want to move these files

Now select Yes for the files which you want to move

Once done, click on Move Duplicate Files

Click on Yes to confirm the action

Tool will now start moving the files to selected folder and show you a confirmation message once action is complete
You can see the action taken by the tool in Status column as well

Recommended Articles

VBA Code to Delete File

Excel VBA and Macros | Productivity and Automation

VBA Code to Delete File

Byexcelsirji

In this article we are going to show you how you can delete file or files using a single line of VBA code. 1. Delete a specific file from the folder, 2. Delete specific type of files from the folder, 3. Delete all files from the folder

How to use IFERROR Function in Excel

Excel Basics | Advanced Excel Techniques | Excel Functions

How to use IFERROR Function in Excel

BySumit Shrimal

This tutorial explains how to use the IFERROR function in Excel to catch and handle errors. It shows you how to replace errors with a blank cell, a different value, or a custom message. You’ll also learn how to use IFERROR with functions like VLOOKUP and INDEX MATCH, and how it compares to other error-checking functions like IF ISERROR and IFNA

How to Color alternate row in excel

Excel Basics | Advanced Excel Techniques | Data Analysis | Data Visualization

How to color alternate rows in Excel: highlight every other row

BySumit Shrimal

This tutorial shows you how to change the row colors in Excel to automatically highlight every other row or every nth row or column in your worksheets. You will also learn how to use Excel’s banded rows and columns and find some helpful formulas to shade rows based on value changes.
Using alternating colors for rows in Excel is a common way to make data easier to read. While it’s simple to manually highlight rows in a small table, it can be very time-consuming in larger tables. A better approach is to automatically alternate the colors of rows or columns, and this article will show you how to do it quickly

Excel Nested IF statement: examples, best practices and alternatives

Excel Functions | Advanced Excel Techniques | Data Analysis

Excel Nested IF statement: examples, best practices and alternatives

BySumit Shrimal

This guide shows how to use the nested IF function in Excel to check several conditions. You will also learn about other functions that can be to use than a nested formula.
When you want to make decisions in Excel, you often use an IF formula. It checks if something is true, then gives one result if it is and another result if it isn’t. If you need to check more than one thing, you can put many IFs inside each other.
Although using multiple IFs is common, it’s not the only way to check several conditions in Excel. This guide will introduce you to some easier and useful alternatives.

VBA to Read Excel Data using Connection String

Excel VBA and Macros | Productivity and Automation

VBA to Read Excel Data using Connection String

Byexcelsirji

VBA to Read Excel Data Using Connection String Sometimes as a programmer you need to read heavy (more then 5 MB) Excel files. There are two ways you can read data from Excel files: Open…

Choose function in excel

Excel Functions | Advanced Excel Techniques | Excel Basics

Excel CHOOSE function

BySumit Shrimal

The tutorial explains how to use the CHOOSE function in Excel, showing you the basics and some interesting examples. While CHOOSE might seem simple on its own, when you combine it with other functions, it can be powerful. Essentially, the CHOOSE function helps you pick a value from a list based on its position. The tutorial also covers some advanced ways to use CHOOSE that you might find very useful.

Leave a Reply Cancel reply

Excel VBA Master Tool Kit