i have data organized the following way and cant change its layout
Name City
Andy Atlanta
Bill Atlanta
Chet Boston
David Boston
Edgar Chicago
Fred Chicago
this data exists in A1: B7
Later in the sheet (c12) have the value chicago entered
I want a drop down in D12 to give me the option of picking only the names in chicago (Edgar or Fred)
Thanks
Bookmarks