In Excel 2007
1. Click the Data tab and click Advanced under Sort & Filter
2. In the popup window, select “Copy to another location”.
3. Click button for “List Range” and select the column or all the rows in the column from which you want to extract unique values.NOTE: The 1st Row is considered heading and hence if you have a value in another row in the same column then this will show up twice (1st row again a heading)
4. Click button for “Copy to” and click on a cell to which you want to extract the unique values to.
5. Select “Unique records only” and click OK. This should extract unique values to the column.
In Excel 2003 & earlier version, Select Advanced filter from Data Menu item and follow the above instructions to extract unique values.
Incoming search terms:
- excel 2003 unique values (66)
- extract unique values excel (55)
- excel list unique values in column (44)
- excel 2010 unique values (38)
- excel 2003 distinct values in a column (38)
- excel extract unique values (38)
- extracting unique values in excel (37)
- extract unique values from excel column (31)
- excel extract unique values from column (31)
- how to extract unique distinct values from a column (30)