I would use Advanced filter to find only unique employee names then copy these
to a new worksheet.

For more info see Debra Dalgleish's site.

http://www.contextures.on.ca/xladvfilter01.html


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 09:27:00 -0800, Newfie809 wrote:

I have a spreadsheet that lists 3600 employees and because some of these
employees work at different locations they are listed more that once, but I
also need the same list on a different spreadsheet but only show that
employee name appears only once. Is there a formula that would extract each
employee and only show once on the second spreadsheet.

Thanks