LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Employee list Dave New Users to Excel 3 January 9th 07 10:29 PM
How do I eliminate a list from an Excel spreadsheet? Pete Excel Discussion (Misc queries) 1 November 30th 06 11:45 PM
Calculate employee hours for employee evaluation? Triesha Excel Worksheet Functions 3 February 9th 06 02:52 PM
Fromula to take employee # out of employee name field mikeburg Excel Discussion (Misc queries) 9 September 12th 05 03:41 AM
employee phone list template Carol Excel Worksheet Functions 1 August 1st 05 05:15 PM


All times are GMT +1. The time now is 02:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"