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

No comments:

Post a Comment