A construction company has 15 project managers and 10 project sites. They work only 15 days in a month. Every month, a project manager will be assigned to a site to inspect the work status. Project manager will be asked to visit the site on any day within 15 working day time frame.
Their excel file has three sheets,
Sheet 1 – (named as Team) – Contains the list of 15 project manager name.
Sheet 2 – (named as Work Allocation) – This will have project manager name under the project site column
Sheet 3 – (named as Unused Resource) – We need to build a formula which will display the project manager names who have not been assigned to any project site.
You can post your solution in the comments section