Articles → EXCEL → Create unique list of elements in excel 2013

Create unique list of elements in excel 2013






List of duplicate elements




Picture showing the sample excel file for creating the unique list

Click to Enlarge


Create unique list




Picture showing the advanced button inside the Data tab of the excel

Click to Enlarge



Picture showing the popup window of the advanced filter

Click to Enlarge



  1. Select the radio button – ‘Copy to another location’.
  2. Select the checkbox – ‘Unique records only’.
  3. Select A1 to A9 in ‘List range’
  4. In ‘Copy to’ fields, select the cell where you want to copy the unique list.
  5. Click Ok.


Picture showing selecting the range in the advanced filter dropdown

Click to Enlarge


Output


Picture showing the unique list of records in the B column of the excel file

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Wednesday, July 6, 2016

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250