The easiest way to do this is to use the advanced filter.

Navigate to the location where you want this data to appear.
Goto the menu DataFilterAdvanced Filter
Select Copy to another location
List range - is the location of the data. So, enter the range of cells where
your data is located (include the column header)
Copy to - this is where you want the extracted data to appear. Since you're
already on that sheet just enter A1.
Select Unique records only
OK

Biff

"dhays" wrote in message
...
I have a worksheet with a list of random phone numbers in column A. The
numbers are repeated a number of times. For example, there may be 100
entries made up of 15 numbers. I would like to be able gather those 15
numbers and list them on another sheet in column A.

Example:
Sheet 1
A
A
C
B
C
D
B

Sheet 2
A
C
B
D

Any ideas.