View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Newfie809 Newfie809 is offline
external usenet poster
 
Posts: 61
Default Excel Spreadsheet Employee list

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