Title:
Prevent Duplicate Values being entered in a List in Excel - Allow only unique values to be entered.
Video:
Description: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 used here is COUNTIF(). Toget the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website www.TeachExcel.com You can also visit the forum there if you have any questions. Have a great day!
Published:
09/Jan/2009
Prevent Duplicate Values being entered in a List in Excel - Allow only unique values to be entered.
Video:
Description: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 used here is COUNTIF(). Toget the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website www.TeachExcel.com You can also visit the forum there if you have any questions. Have a great day!
Published:
09/Jan/2009
No comments:
Post a Comment