Getting unique values in Excel by using formulas only

[koskesh]

Hello,

I have an issue with an workbook.
The workbook has 4 columns. I need the unique values (4 digit numbers) from the first colum in another field. (column F, row1)
My problem: The column A is dynamic, I add values every day
The output should like this:

1101;1102;1103;1104

Thanks for the help!

 

[NeonRedSharpie]

You can just copy the column and use "Delete Duplicates"