MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Extracting a list of non-duplicates

Posted by Michael J. on January 28, 2002 1:45 PM

I have a list of items (e.g. apple, orange, apple, banana, apple, orange, peach).

I want to provide the range of my list and get back what type of fruit is in the list, with the type of fruit only appearing once (e.g. apple, orange, banana, peach).

How do I do this?

Posted by Richard S on January 28, 2002 1:47 PM

Highlight your list, and use the Data Advanced Filter command, checking the unique records only box.

Posted by Chris D on January 29, 2002 11:52 AM

as below, but check the "copy to new location" box and provide a cell to copy it to...... this will paste those unique values to the cell you specify, rather than actually filtering the original range (assuming that's what you wanted !)