Posts tagged ‘Validation’

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


Everyone needs a little Validation from time to time…

Continue Reading October 24, 2012 at 1:29 pm

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


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

Continue Reading October 17, 2012 at 3:07 pm

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


Dueling Excel – Episode #75 with Mike and Bill!

Continue Reading April 15, 2011 at 2:34 pm

Dueling Excel – Dynamic Validation VLOOKUP: Podcast #1379


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

Continue Reading April 8, 2011 at 3:10 pm

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!

March 18, 2010 at 10:58 am Leave a comment

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!

October 26, 2009 at 9:00 am Leave a comment

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!

January 27, 2009 at 9:00 am Leave a comment

Older Posts


Learn Excel from MrExcel

Learn Excel Podcast Splash Screen

The Excel Beginners Book:

"Don't Fear The Spreadsheet" - by Tyler Nash, Bill Jelen, Tom Urtis and Kevin Jones

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 738 other followers

Live Lessons Excel 2010 DVD

"Live Lessons Excel 2010" DVD

RSS MrExcel Recent Articles

  • An error has occurred; the feed is probably down. Try again later.

Recent MrExcel Tweets

MrExcel Podcast Archive