Excel Data Validation… Let’s Push it to the Limit and Beyond

The Magic of Data Validation

Introduction

Dynamic Data Validation… is a Game changer in Excel, at the basic level it controls what a user can enter or cannot enter in a cell. It also makes data entry easier and ensures the integrity of your worksheet by avoiding typing errors when users can simply select an option from a drop list.




However, in more advanced scenario drop lists can make a regular worksheet look as a dynamic dashboard.

In this article, we explore the full potential of drop lists by creating basic drop lists, diminishing drop lists and then we create dependent drop lists with 6 levels of dependency. We will learn about the extreme power of combining Drop lists with Dynamic arrays and touch the limit of what Data Validation can do.



I delivered this topic at the Global Excel Summit on July 22nd. 2020 at 6:00 PM (GMT-5 Eastern Standard Time US & Canada)




You can download the exercise File and follow along by clicking on the Green button

A picture containing ball, player, holding, sitting Description automatically generated




You can also read my step by step guide that maps to this tutorial, it’s a reference book for you to keep and is also available for you to download by clicking on the Orange button.

A picture containing drawing Description automatically generated

I would appreciate receiving your comments about this tutorial, blog and video in which I put a huge effort and a lot of time.

 

Share This Post
Have your say!
1 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.
SUBSCRIBE NOW
close-link