A | B | C | D | E | F | G | H | I | J | K | L | M | |
1 | no.1 | no.2 | no.3 | no.4 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
2 | 1 | 5 | 6 | 8 | Y | Y | Y | Y | |||||
3 | 2 | 7 | 8 | 5 | Y | Y | Y | Y | |||||
4 | 4 | 3 | 1 | 6 | Y | Y | Y | Y | |||||
5 | |||||||||||||
6 | TABLE 1 | TABLE 2 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 73.6px;"><col style="width: 73.6px;"><col style="width: 73.6px;"><col style="width: 73.6px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
dear experts,
would someone please help me out how to use formula that number from Table 1, e.g. no.1, 5, 6 ,8 from table 1 then use "Y" to show in table 2?
thanks in advance from gigi