Excel Duplicates Finder with Treeview using VBA and VB Net



Excel Duplicates Finder with Treeview using VBA and VB Net

Excel Duplicates Finder with Treeview using VBA and VB Net

This tool has an added feature which includes a treeview control to navigate large duplicate search ranges.
The video demonstrates a search of over 50,000 cells and finds over 3000 values that are duplicated in under 1 second. Recent releases of Excel have provided a means to highlight duplicate values in a range. However, every value is highlighted the same color. This tool highlights up to 54 different duplicate values different colors. If more than 54 duplicate values are found then the color coding index roles over and begins reusing colors.
Example: two cells that have “1” in them will be colored green. three cells that have “duplicate” in them will be colored yellow.
This tool is the result of minimal VBA code and a reference to a custom VB.Net .tlb class library.

If you are interested in the source code, just let me know.
I am considering re-making this tool for even easier use and higher speed.