Dependent Drop Down List Excel - Unique Values -

Dependent Drop Down List Excel - Unique Values -

i need connect 3 lists of info , set them drop downwards lists. started making named ranges, getting of unique values , such.

essentially followed instructions on website: http://www.get-digital-help.com/2010/07/17/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/

after next website, placed these 3 drop downs in same row, 1 cell apart. however, need have same 3 drop downwards sequence in next row down. when seek this, sec row dependent on values of first one. if pick initial value first row not same initial value sec row not work correctly.

does see way around this?

thanks!

as is, creating unique list first drop downwards box in first row. unique list sec drop downwards in first row dependent upon value nowadays in first drop downwards on first row. sec list looks value selected in first drop downwards of first row , populates corresponding values every instance of value picked first drop down. list repopulates , changes every time select new value in first drop downwards of first row.

when creating sec row, sec drop downwards reading first row's unique list. there no unique list based upon value have selected in first drop downwards of sec row sec drop downwards of sec row.

the workaround create new lists drop downs in sec row.

from link:

3.type "=index(product, match(0, countif($b$1:b1, product)+(order<>sheet1!**$d$2**), 0))"

the bolded part problem. when drag formula, ties d2 on sheet1. need create list using formula, alter $d$2 $d$3 or whatever cell address of first drop downwards row.

excel excel-2010