create a list of unique values

B

Bill Brehm

I have a list of items in a column of a spreadsheet. I want to get a new
list of items that contains every entry from the first but removes duplicate
entries. If necessary I can presort the first list to get all duplicate
entries adjacent to each other. I would like to do this with worksheet
functions. I could put the function at the top of a column then drag the
function down until I have empty cells meaning I have all entries from the
original without duplication.
 
G

Gord Dibben

Data>Filter>Advanced Filter.

Check "Unique records" and "Copy to another location"


Gord Dibben MS Excel MVP
 
O

OssieMac

Hi Bill,

You can use Advanced filter to create a new list of Unique values. In xl2007
you will find it on the Data ribbon under the Sort & Filter block. On earlier
versions select menu item Data-> Filter -> Advanced filter. Just follow the
prompts and ensure that you check Copy to another location option and Unique
option.
 
B

Bill Brehm

Thanks everyone. That's exactly what I needed and I was never aware of that
before.
 
Top