Select the column by clicking top of the column, then go to data-validation, select custom and type the
custom rule =COUNTIF(A:A,A1)=1
Showing posts with label duplicate entries in excel. Show all posts
Showing posts with label duplicate entries in excel. Show all posts
Thursday, February 27, 2014
Remove duplicate entity from a column
Select the column by clicking top of the column, then go to data-validation, select custom and type the
custom rule =COUNTIF(A:A,A1)=1
Subscribe to:
Posts (Atom)