Sorta Indirect - 1130 - Learn Excel from MrExcel Podcast

Greg wants to set up dynamic validation, but he has a wrinkle....Once someone chooses from the first data set, he needs to append the word My before that answer to get to the name of the second data set. Episode 1130 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #937 - Dynamic Validation

I've talked about making the list for your data validation automatically grow with the list. In the past, I've used a macro or the OFFSET formula, but today Morne sends in a beautiful solution for either Excel 2003 or Excel 2007 to build a dynamic validation list. Episode 937 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 892 - Validation Formula

Jon wants to set up validation to see if the result of a calculation exceeds a certain value. In Episode 892, we take a look at using Data Validation with a formula.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 720 - Dynamic Validation

Jonathan is frustrated that his validation scrollbars start in the midst of several blank cells that he set up in his validation list. He was doing this to allow room for future growth in the list.

Instead, Episode 720 will show you how to set up a dynamic named list using the OFFSET function.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 718 - AutoComplete vs Validation

Laura, Erik, and Howard all sent in similar workarounds to podcast 713. Today in Episode 718, we will take a look at how to offer a validation dropdown that will allow keyboard afficianados to enter values quickly.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 713 - Validation Woes

In Episode 713, a link to http:/www.mrexcel.com/excel_video_training.html, another link to http://www.mrexcel.com/video2003.html. Then, how to set up a dropdown list in Excel, but some frustration that the dropdown list won't let you type the first few letters of the value.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 584 - Refreshable Validation

Store your validation lists on a separate worksheet and have the dropdown boxes automatically expand when you add new items to the list. Episode 584 shows you how. If you'd like to try this out, download the sample workbook. Monday in the USA is our Labor Day holiday and I'll be back Tuesday, September 4th.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 583 - Validation Lists Elsewhere

Brent asks how you can set up validation lists on another worksheet. This is generally considered invalid, but Episode 583 shows you how to pull it off.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 491 - Tricky Validation

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.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 475 - Double Validation

Excel MVP from Brazil Robert Martim shows how to set up a 2-level data validation. Episode 475 shows you how.

Download the file used in this podcast from RM2.zip

Episode 461 - March Madness

You are invited on Monday to download MrExcel’s NCAA bracket and enter his free NCAA pool. The winner will get their choice of books from the MrExcel store. In today’s Episode 461, we will take a look at the Data – Validation commands used to make the NCAA bracket selection worksheet work.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 383 - Dependent Validation

Setting up data validation lists, where the second list is dependent upon the answer given in the first dropdown box. Episode 383 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 381 - Indiscriminate Validation

Sometimes you want to have cell validation, but you need a way for the person using the spreadsheet to override the validation list, especially in the case where there is a brand new value that you have not yet added to the list. Episode 381 shows you how to have the Validation dropdown ease up.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 380 - Validation Messages

When you set up a validation dropdown, Excel won't let someone enter an invalid value. Add some text to guide the person using the spreadsheet. Episode 380 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 379 - Offsheet Validation

Yesterday's netcast showed how to set up data validation to create a dropdown for a cell. The one problem is that someone might inadvertently delete a row from your list of values. Technically, Microsoft says that the validation list can not be on another worksheet, but Episode 379 shows you the workaround.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 378 - Cell Dropdown

If you are creating a worksheet for someone else to fill out, why not provide dropdowns where the person can choose the valid values from a dropdown list? It is easy to do. It makes life easier for the person filling out the form. It makes sure the data that comes back to you is correct. Episode 378 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!