I love working with (defined) tables connected to pivot tables. I also use GETPIVOTDATA to create dynamic reports with nice layouts. Sometimes I have drop downs list (Data validation) for choosing product, year, customer etc.

But is it really possible in Excel (2010 or 2013) to create a drop down list (data validation) that show unique items from a field in my (defined) table?

Please, I really, really need this feature

Tobias