create a list of unique values

[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.

 

[JP]

Check out http://tinyurl.com/2y7u4r


HTH,
JP

 

[Gord Dibben]

Data>Filter>Advanced Filter.

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


Gord Dibben MS Excel MVP

 

[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.

 

[Bill Brehm]

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