Have you ever found yourself in a situation where you have thousands of duplicate values in a column? Perhaps you were importing client data into MS Excel from an accounting system or simply combining data in MS Excel. But alas, you end up having duplicates values in a given column. If you are faced with such a dilemma we certainly have a solution for you. By using the Advanced Filter –Unique Records Only option you can generate a list of unique records in a given column.
Click here to access this Microsoft Excel tip.
Applies To: Excel 2003, 2007, 2010