ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Scheduling employees by dates... LOOKUP or FILTER? (https://www.excelbanter.com/excel-worksheet-functions/55416-scheduling-employees-dates-lookup-filter.html)

ssleene

Scheduling employees by dates... LOOKUP or FILTER?
 
I'm trying to use Excel Spreadsheet to keep track of employees based on
scheduled work. I have dates on the top horizontal bar and project names and
employees name on the vertical. I assign employees to certain projects and
schedule them until the project is done. What I want to know is when an
employee is complete with the project, show all of the availble employees
names to show up at the corresponding availble date from the top.

Any suggestions?
--
sslee


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com