Hi guys,
I have a spreadsheet in which there are multiple users in Column A (which I update almost monthly). Column B shows the period during which they can work in a week for example Sat - Sun means a user can work on Saturday and Sunday. Then the Columns K till Column AB shows the type of skills and "1" represents that they have that skill.
I need to extract 2 things from this data which is what a user can do on a certain day. For example; if today is Monday and I want to know the employees that can stow and if it is Tuesday, I want to know the employees that can pick. I keep updating this list every now and then.
And another thing that I want is to have a summary like how many stowers I have on Monday and how many Instructors on Thursday.
I tried using PivotTable for these but its getting to complicated that way. If anyone could help in this or guide me on how to do this, I'd really appreciate it.
Bookmarks