Generate list from column

[Guest]

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.

 

[T. Valko]

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 Data>Filter>Advanced 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