waimea
07-06-2018, 01:27 AM
Hi,
I am trying to populate several data dependent data validation lists using LARGE to find the 15 largest values, I use INDEX and MATCH to find the name of the top 15 largest values and finally I am using OFFSET to create a dynamic list that auto updates. I am not sure on how to get dependant drop downs with a named range and the OFFSET function.
The offset function is used in drop down 2 and 4. Drop down 1 and 2 are standard data validation lists.
See attached worksheet.
Regards,
Waimea
I am trying to populate several data dependent data validation lists using LARGE to find the 15 largest values, I use INDEX and MATCH to find the name of the top 15 largest values and finally I am using OFFSET to create a dynamic list that auto updates. I am not sure on how to get dependant drop downs with a named range and the OFFSET function.
The offset function is used in drop down 2 and 4. Drop down 1 and 2 are standard data validation lists.
See attached worksheet.
Regards,
Waimea