copy unique value from column to another column

[Bax]

Hi All,

Probably a very easy question, but couldn't find a thread similar to this.

In column A I have weeknumbers (duplicates occur). In column C I want all unique weeknumbers from column A.
Data in column A starts at cell A6, the blanks are not to be copied. Pasting in cell C2 downward. Column C then to be sorted smallest to largest.

See attached file with the example data.

What will need to be the VBA code to obtain the above?

Thanks all for your input!
Peter

[sourabhg98]

Hi
You can do this with the help of a helper column
So in cell B2 put this
=IFERROR(INDEX($A$6:$A$100,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$6:$A$100),0,0),0)),"")
and copy down

Now in C2 put this
=IFERROR(SMALL($B$2:$B$100,ROW()),"")
and copy down

This works for 100 rows extend to suit requirement..
Hope this helps!!

[Jakobshavn]

Give this a try:

Please Login or Register  to view this content.

[AB33]

If the week days are numbers, try

[Bax]

Ah perfect! You all helped me understand the VBA a bit better ;-)

Case closed, stars earned!