How To Creat A Multiple Data Validation In The Same Cells In Excel

In this video we’ll learn how to incorporate multiple criteria into the same cells to prohibit invalid entries when using Data Validation. We’ll also learn about the Ignore Blank option and incorporate the AND and MOD functions.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.


 

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , , ,

2 Responses to How To Creat A Multiple Data Validation In The Same Cells In Excel

  1. Penny Krawczyk January 17, 2016 at 4:47 am #

    Great tip! Thanks so much…

Leave a Reply