I need some help. I have some large tables showing the names of various managers and their empolyees they manage. In column 1 is the list of the various managers, and in column two are the names of the associates. The manger names repeat frequently. For example:

Bob
Bob
Bob
Bob
Jane
Jane
Jane
Kevin
Kevin
Kevin
Kevin
Kevin

I want to use the form control options and create a drop down menu showing the list of possible managers....but I don't want the list to show any repeating values. I know that I can manually create a list with single values for each manger, but I'm wondering if there's an easier way.

Is there a way to take a list of data that has repeating values, and then have Excel summarize the list to exclude repeating values?

Thanks!