Gord's suggestion works. In the future, I would suggest you keep
three separate worksheets for this purpose.

One, to list employees, indexed by some kind of identifying criteria
(e.g. SSN)

Two, to list locations, with a unique code assigned to each.

Three, to list location assignments. Here, you link an employee code
to a location code - one record for each assignment. You can then use
VLOOKUP to pull up additional references to either location or
employee list, as well as list unique attributes for specific
assignment (e.g. times and days the employee works the particular
location).



On Nov 12, 12:27 pm, 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
--
Newfie