Articles → EXCEL → Create Unique List Of Elements In Excel 2013

Create Unique List Of Elements In Excel 2013

List Of Duplicate Elements

Create Unique List

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.

Output