Episode # 491 - Tricky Validation

Sponsored by

Learn Excel from MrExcel

Check out this book for more tips
similar to this lesson!

Friday, April 20, 2007

Mike writes in with a question that is way too hard for a Friday, and way too hard considering it is dawn in Maui. Mike has what sounds like a simple task - a checkbook register in Excel, but needs to create a tricky validation that will allow either an integer check number or one of a handful of values such as ATM, EFT, etc. Episode 491 shows you how to set up data validation to handle this problem.

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 5 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: Validation

More Excel Video Lessons

If you like this video, there are hundreds of 2-5 minute videos available here: