Select distinct entries from a list (2000 SR 1)

Topic

New Reply

I have a column with 1000 rows and I want a list of distinct values. Any ideas of the best way to do this?

For example

the list:
fred
john
fred
james
sue
sue
jane

distinct list:
fred
john
james
sue
jane

I am doing this too often to import into access and use Select Distinct query.

Reply | Quote

Replies

Here’s a link to Chip Pearsons Site decribing how to do this:

Extracting Unique Entries

Reply | Quote

The code in This Post will delete all rows that have duplicates in column A. Is that what you want to do, or do you want some kind of separate list.

Reply | Quote

Make a pivot table. Use “the list:” as the row source and “Count of the list:” as the data field. Leave the column source blank.

Reply | Quote

Thanks for the reponse guys, the link to http://www.cpearson.com/excel/duplicat.htm has got me close enough.

I wonder can anyone combine the “extracting unique entries” and “eliminating blank cells” formula on these pages into a function that would do exactly what I am after.

thanks

Reply | Quote

If you really mean that you want a function, then your answer is on John Walkenbach’s tips. You would just need an IF statement in the code to skip over blank cells.

You can do this manually with the Data | Advanced Filter | Unique Records only. Microsoft has an example. HTH –Sam

Reply | Quote