Avoid Duplication

[Arslannaz]

Hi can someboday please help?

I am working in Sheet 2 in Column A and I am copying entries from Sheet 1 in column A by pressing "=" in Column A of Sheet 2 so all data from Sheet1 column A is coming to sheet 2 colum A. 

By doing so I want to avoid duplicate entry in sheet 2 column A. 

How I can do so please?

[#2]

@Arslannaz 

Hey,

On Sheet 2 column A, select all cell with values, go to Data tab and on Data Tools options click on "Remove Duplicates".

Hope it helps.