Aethelwulf
New Member
Hello,
I have a staffing plan-problem-example that is solved in the attached worksheet. It shows different possible shifts in a small matrix and to the right it shows "multiplicity" indicating how many times the shift was used.
Farther to the right I wish to have an automatic generated table that Only shows the shifts that was chosen and what date and time that shift includes. So in this case the shifts with a number greater than 0. It could however be another shift that was used (in my larger model) and then I'd like that one to be shown in the table instead.
I've manually inserted some shifts in the table but wonder how to format the cells to generate the table automatically?
Best regards,
Anders L.
I have a staffing plan-problem-example that is solved in the attached worksheet. It shows different possible shifts in a small matrix and to the right it shows "multiplicity" indicating how many times the shift was used.
Farther to the right I wish to have an automatic generated table that Only shows the shifts that was chosen and what date and time that shift includes. So in this case the shifts with a number greater than 0. It could however be another shift that was used (in my larger model) and then I'd like that one to be shown in the table instead.
I've manually inserted some shifts in the table but wonder how to format the cells to generate the table automatically?
Best regards,
Anders L.