Filtered Names to Cells?

[Wamhoi]

Is there any way to copy the unique names within a filtered column into a seperate column

For example:
Column A has the numbers 1,2,2,2,3,4,4,1,2 from rows 2 to 10 without blanks. A1 is the filtered title "Numbers"

I would like Column B to list 1,2,3,4 (only unique numbers) from rows 1 to lastnumber (in this case row 4)

Thanks.

 

[Andrew Poulsom]

You can use Advanced Filter:

http://www.contextures.com/xladvfilter01.html#FilterUR

 

[Wamhoi]

Thanks so much!