Prevent Duplicate Values being entered in a List in Excel - Allow only unique values to be entered.

http://www.TeachMsOffice.com
This tutorial shows you how to create a list in Microsoft Excel which only contains unique values. This means that a user cannot enter a duplicate value or word or phrase in a list.

The words or numbers or characters must be exactly the same to be considered a duplicate entry. This method used the Data Validation technique in excel. The formula/function used here is COUNTIF().



To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachExcel.com You can also visit the forum there if you have any questions.

Have a great day!

Category:

Education

Tags:

• microsoft
• excel
• helpful
• tips
• tricks
• formulas
• functions
• countif()
• data
• validation
• custom
• lists
• unique
• values
• no
• duplicates

[wgprabath]

thank u so much sir

[8MCDonalds8]

Nice but unfortunately didn't do me any good. Good vid tho. I am creating a list of several thousand company names. I need to know that the new name I am intend 2 enter, didn't already get entered. Wud I need 2 do that 4 evry new name I enter? If so, then it woud b quiker if i just lukd 4 the name and confirmd that it wasnt yet entered. 5 stars