Test Your Microsoft Excel Skill Level – Case Study 6

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.

Download the excel file

You can post your solution in the comments section

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.