You too can be unique in Excel [VIDEO]

A uniquely useful technique

When dealing with data lists in Excel it is a common requirement to extract the unique entries from a field. Excel has a built-in feature that will create a unique list.

I find the easiest way to extract the unique list is to copy the column you want to work with to a blank sheet. This makes the process straightforward compared to working with the column in the whole data list.

After copying the column follow these instructions (Video at the bottom of the post)

1. Ensure the field name in row 1 is bold – this helps Excel identify it as the heading row (if you don’t you may see an error dialog).

2. Select any cell in the list

3. Click the Data Ribbon tab

4. Click the Advanced icon in the Sort & Filter sectionAdvanced Filter icon

5. Click the Copy to another location option

6. Tick the box Unique records only

7. Click inside the Copy to: box and click in cell C1 (see image below)

Advanced Filter Dialog

8. Click OK

These steps become quite quick with practice.

Unique List


Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.