Formula adapted from another post...

Assuming you have names in Sheet 1 Col B upto row 1200, no header row
Enter in C1
=COUNTIF(B1:$B$1200,B1) copy down till C1200

Go to Sheet 2
in B1 paste the following
=IF(ROWS($1:1)<=COUNTIF(Sheet1!C$2:C$1200,1),INDEX (Sheet1!B$2:B$1200,SMALL(IF(Sheet1!C$2:C$1200=1,RO W(Sheet1!B$2:B$1200)-ROW(Sheet1!B$2)+1),ROWS($1:1))),"")
and press CTRL-SHIFT-ENTER and copy down... till you get a blank. You may
copy it further down for future additions of names in Sheet 1.

"NightLord" wrote:

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.