生成一个过滤的动态下拉列表

I need two dynamic drop down lists for data validation. One containing a unique list of continents to choose from, and then the second list which is a dynamically generated subset of countries based on the continent selected. The data is not in any particular order:I need two dynamic drop down lists for data val