Validate Unique Values in an Excel Table | Everyday Office 053
969 views · Published 11 May 2017 · 8:17 · Indexed 13 October 2026
Channel: Neil Malek · 2017 · Education
Can I guarantee that the value I type into a table is unique? With Data Validation, the COUNTIF function, the INDIRECT function, and Table dynamic named ranges, you can create a column of your spreadsheet that is only unique values. Neil Malek from Knack Training recorded this tutorial video to create a setup that would help building a data-driven Visio organization chart. Music is "Ninja Monkey" by Andrew Applepie http://soundcloud.com/andrewapplepie Knack Training is a software and professional development training company from Orlando, FL. Neil Malek, principal at Knack Training, records software tutorials everyday through the series Everyday Office. Knack Training is recording their entire library to provide lifetime value through KnackCourses.com - soup-to-nuts training in Excel, Outlook, and more. Subscribe to my channel here: https://www.youtube.com/subscription_center?add_user=neilmalek Subscribe to the quarterly tutorial ezine: http://knacktraining.com http://knacktraining.com http://knackcourses.com http://facebook.com/knacktraining http://twitter.com/neilmalek http://instagram.com/neilmalek
