Excel Duplicates Finder using VBA and VB Net



Excel Duplicates Finder using VBA and VB Net

Excel Duplicates Finder using VBA and VB Net

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.