Duplicate data prevent by data validation .

Different time we face a problem duplicate data . So, I Publish this ,Duplicate data prevent by data validation .In data validation use a function and see magic.

Ms Excel Duplicate value delete by one click.

Ms Excel Duplicate value delete by one click.Some time need duplicate value delete but it is difficult and time killing but if use this sheet easily delete duplicate value.Save time and enjoy.

Ms Excel duplicate value highlights very easy way.

Ms Excel duplicate value highlights very easy way.

Ms excel Duplicate Thing find by Function.

Ms excel Duplicate Thing find by Function .We know different way duplicate data find .It is a one process/function find duplicate value.I seem easy process find duplicate function.If find duplicate show duplicate another way show no duplicate in this column.