Forum Discussion
Avoid Duplication
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?
1 Reply
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.
