Copy cell from the list if it does not exist already

[Vokain]

I have a set of numbers in column "C16:C1999" most of them are repetetive and I would like to have a list of them in column A but only unique not repetetive.

Could anyone help me?

 

[Yahya]

in A2 try this array formula

=IFERROR(INDEX($C$16:$C$1999,MATCH(0,COUNTIF($A$1:A1,$C$16:$C$1999),0)),"")

array formula must enter by Ctrl+Shift+Enter

 

[RichardMGreen]

You could also try the advanced filter under the data menu.
That will allow you to get a list of unique values and put them anywhere on the same sheet.