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 FREE BOOK

Receive my Amazing Textbook “Pivot Tables From Zero To Hero” Totally FREE when you subscribe below to our emailing list.
SUBSCRIBE NOW
close-link