If you want to effectively paste a list of the unique values
try this:

Your list will need a column heading. (eg Names)
I'll assume A1:A14 contains your list, with A1: Names

B1: Names

Select your list of values A1:A14

From the Excel main menu:
<data<filter<advanced filter
Check: Copy to another location
Copy to: B1
Check: Unique records only
Click the [OK] button

That will create a list of the unique names under cell B1

Is that something you can work with?

Note: There are also ways to have the list built on a different worksheet in
the workbook and to use formulas, instead of Advanced Filter.

Post back if you have more questions.
***********
Regards,
Ron

XL2002, WinXP


"cindi" wrote:

I am looking for a way to take a list of values from one column, and in
another column display a list of distinct items in this list.

So if in column A I have the following values:
Alan
Bob
Charlie
Alan
Alan
Alan
Charlie
Dave
Charlie
Bob
Edgar
Bob
Bob

In column B (or another worksheet or whatever) I am expecting a list like
this:
Alan
Bob
Charlie
Dave
Edgar

Is there a way to do something like this?

Thanks,

Cindi