Prevent Duplicate Entries in a Range with Excel Data Validation
This video shows "How to prevent users from entering duplicate values in a column with Data Validation in Excel with easy steps"
It is one of the best trick to implement it on your data if you don't want any duplicate entries to be entered in the column or range. In other words, a range which will be restricted to have only the unique entries in the range.
In this 5 minutes, using 3 simple steps, you will become an expert of using this feature and then can leave awesome impression on your colleagues. :)
Following are 3 Easy and simple steps...
1) Select the specific range
2) Data Validation - Custom function
3) Use of COUNTIF function
For more tips & tricks, visit us at http://www.exceltip.com/
In case of any simple or complicated "Excel" query, you can ask to our experts for instant solution at http://www.excelforum.com/