I'm kicking myself in butt here.
I have two sheets. In Sheet 1, Column B there is a row of names- some of
which are duplicates. Bob will show up as often as he has called in.

In Sheet two, I want Column A to populate itself with every name that shows
up in Sheet 1, Columb B... but only once for each name. Thus, even though Bob
has called in 100 times, I just want his name to show up once on Sheet 2.

I'm having isses because I want the Column in sheet 2 to be dynamic. I tried
a pivot table, with a CountIf function, but for the layout it wants something
in the field next to it. I JUST want the row to do the names. Nothing more.