Hello I am trying to get a list of all names found in a column but exclude duplicates... I know this can be done in a pivot table but I need the names in a drop down box... if I use the pivot table as the source it will pick up "Grand Total" as a name.

The number of people can increase from week to week...