How to Find Duplicate Data in Excel using Data Validation and Conditional Formatting - Part 1

How to Find Duplicate Data in Excel using Data Validation & Conditional Formatting Way 1: Click Home - Conditional Formatting - Highlight Cells Rules - Duplicate Values. Way 2: Select the data - Data Validation - Apply custom formula into Custom option from the drop down to restrict duplicate entries Free Downloads: https://prabastech.com/free-downloads/ Excel Training in Tamil:    • Learn VLOOKUP Excel Function Part 1 in Tamil   ~-~~-~~~-~~-~ Please watch: "Play with Duplicate Data in Excel - Part 2 - Highlight, Remove, Trigger"    • Fix Duplicate Data in Excel - Part 2 - Hig...   ~-~~-~~~-~~-~