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


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


Your Email Id  
Query/FeedbackCharacters remaining 250