Values in each cells(A) represented back at cells(B) but no repetition if some cells(

I did my search, but cant find and knows what key search to look/type for...

If i have data A1 through A10, such as 1 1 2 2 2 2 3 3 3 3

How can i get column B1 through B3 as 1 2 3 ?

Im sorry if i repost, i really dont have in mind what kind of title for this question...

thank you very much.

Go to Data|Filter|Advanced Filter.

Select: copy to another location

List Range: A1:A10

Copy to: B1

Select Unique Records Only

Click Ok

There are VBA solutions... if you googles something like Unique Values & Excel

There is also a free addin that has a formula to do it....

If you download and install Morefunc.xll from here: http://xcell05.free.fr/morefunc/english/ you can use the Uniquevalues() function.

Simple select the range in column A you can go beyond A10 even if there are blanks that might be filled in later.

Then select a range in column B that will surely return all unique values... say B1:B10

Then in the formula bar enter something like: =UNIQUEVALUES(A1:A100,1) where A1:A100 is your range of interest. Then hold the CTRL and SHIFT keys down and hit ENTER... a list should populate in column B