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!

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!