Learn Excel 2010 – “Truly Unnecessary Validation”: Podcast #1607

Everyone needs a little Validation from time to time…

Learn Excel 2010 – “Truly Dependent Validation”: Podcast #1606

A Perfect Answer…But It Won’t Work. Dependent Validation – ‘Validated’!

Dueling Excel – Dynamic OFFSET or INDEX?: Podcast #1384

Dueling Excel – Episode #75 with Mike and Bill!

Dueling Excel – Dynamic Validation VLOOKUP: Podcast #1379

Dueling Excel uses Table Nomenclature for a Dynamic Validation List . . .

Validation Tooltip Trick – Episode 1191

This isn’t so much of a dueling podcast as Bill being obnoxious and breaking Mike’s worksheet. Changing the location for the Validation Tooltip box? Maybe there is a use for this, or maybe not. Episode 1191 will show 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!

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!