drunktrainpolka
New Member
- Joined
- Mar 13, 2015
- Messages
- 5
hello...
i am getting beaten up on this one.
we have various labs. these labs are associated with various training modules related to safety - each lab has their own requirements and are listed as 'Xs'. so far so good.
on another sheet i have a list of students and employees. and again a list of the labs. i want see the training modules to be assigned to each person based on the labs they work in (e.g., 1, 2, 5).
i could use a super long if statement but i am looking to use arrays to keep the formula simpler and smaller.
<tbody>
</tbody>
<tbody>
</tbody>
how do i output this:
<tbody>
</tbody>
i am getting really beat up on this...
thanks in advance....
kiko
i am getting beaten up on this one.
we have various labs. these labs are associated with various training modules related to safety - each lab has their own requirements and are listed as 'Xs'. so far so good.
on another sheet i have a list of students and employees. and again a list of the labs. i want see the training modules to be assigned to each person based on the labs they work in (e.g., 1, 2, 5).
i could use a super long if statement but i am looking to use arrays to keep the formula simpler and smaller.
safe 01 | safe 02 | safe 03 | safe 04 | safe 05 | safe 06 | safe 07 | safe 08 | safe 09 | |
lab 01 | x | x | x | ||||||
lab 02 | x | x | |||||||
lab 03 | x | x | x | x | |||||
lab 04 | x | x |
<tbody>
</tbody>
lab 01 | lab 02 | lab 03 | lab 04 | |
mary | x | x | x | |
joe | x | x | ||
luke | x | x | ||
jim | x | x | x | x |
<tbody>
</tbody>
how do i output this:
safe 01 | safe 02 | safe 03 | safe 04 | safe 05 | safe 06 | safe 07 | safe 08 | safe 09 | |
mary | x | x | x | x | x | x | x | ||
joe | x | x | x | x | x | ||||
luke | x | x | x | x | x | x | |||
jim | x | x | x | x | x | x | x | x |
<tbody>
</tbody>
i am getting really beat up on this...
thanks in advance....
kiko