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. Follow the steps below on how you can remove duplicates by generating a unique list of values in a column. Â
Applies To: Excel 2003, 2007, 2010
1.        The screen shot below will be used as an example for this tip
2.        Select the Data Tab, then Advanced under the Sort & Filter group
3.        Select as per screen shot below
N.B. When selecting the list range, ensure that the cell with the list heading is also selected
4.        Select OK
 5.        Only unique records will be extracted as displayed below in Column B
If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.
Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations
