In this video I explain 2 ways to remove duplicates or create a unique list of values in Excel.
1. First we look at the Remove Duplicates features in Excel.
2. Then I share a macro that does the entire process in one click.
The Excel workbook that contains the macro is available for free download at the following link.
The macro can be copied to your Personal Macro Workbook and run with a button that is added to the Ribbon (toolbar).
Register for the Free Webinar on The 7 Steps to Getting Started with Macros & VBA.