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