Double Validation Video Tutorial

[Unregistered]

I've been using the above tutorial however I can't actually read the formulas properly which is making it extremely frustrating to try and replicate?! Can anyone please post the whole formulas needed for the named ranges please?!

 

[doofus1981]

Me too!!!!!!!!!!!!! SOMEONE PLS HELP!

 

[MrExcel]

There are two tutorials...
http://www.mrexcel.com/Excel_Dependent_Validation_training.html
http://www.mrexcel.com/Excel_Double_Validation_training.html

For the second video, the Continents range is defined as:
=OFFSET(Sheet1!$A!1,0,0,1,COUNTA(Sheet1!$1:$1))

Around 1:50, Robert talks about the nCol named range. It is
=MATCH(Sheet2!IV1,continents,0)

Then, Countries is:
=OFFSET(Sheet1!$A$2,0,nCol-1,COUNTA(INDIRECT("Sheet1!"&ADDRESS(1,nCol)&":"&ADDRESS(65536,nCol)))-1,1)

Bill