In Sheet two, I want Col A to populate itself with every name that shows
up in Sheet 1, Col B... but only once for each name.

Here's one way to drive it out dynamically in Sheet2

Source names assumed in Sheet1, in B2 down

In Sheet2,
In A2:
=IF(Sheet1!B2="","",IF(COUNTIF(Sheet1!B$2:B2,Sheet 1!B2)1,"",ROW()))
Leave A1 empty

In B2:
=IF(ROWS($1:1)COUNT(A:A),"",INDEX(Sheet1!B:B,SMAL L(A:A,ROWS($1:1))))
Select A2:B2, copy down to cover the max expected extent of source data in
Sheet1's col B, say down to row 500? Hide away or minimize col A. Col B will
return the required results, all neatly packed at the top
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---