Prevent Duplicate Entries in Excel September 02, 2016 This example teaches you how to use data validation to prevent users from entering duplicate values . 1. Select the range A2:A20. 2. O...Read More