Hi all,
I am struggling with a problem and don't know from where to start. I have two tables, one has the combinations that goes along till all the 3 possible digit combinations. And another table where I have different ranges. The idea is to find out which combinations (from table 1) are missing from ranges in table 2.
For example, in below tables the combination "122" from table 1 is missing in table 2 (Range1, Range2, Range3 combined). But a combination of "121" exist in Row 5 (of Table 2), "111" exist in Row 8 and "135" exist in Row 9.
In the end, the target is to get the list of all missing combinations in table 2. Here are both tables and for simplicity not all the possible combinations are given in Table 1:
| Table 1 |
1 1 1
1 1 2
1 1 3
1 1 4
1 1 5
1 2 1
1 2 2
1 2 3
1 2 4
1 2 5
1 3 1
1 3 2
1 3 3
1 3 4
1 3 5 |
Table 2:
Index | Range1 | Range2 | Range3 |
| 1 | 5 | 5 | 5 |
| 2 | 3-4 | 3-4 | 3-4 |
| 3 | 3-5 | 1-2 | 3-5 |
| 4 | 3-5 | 3-5 | 1-2 |
| 5 | 1-2 | 2 | 1 |
| 6 | 1 | 4-5 | 4-5 |
| 7 | 2 | 1-2 | 1-2 |
| 8 | 1 | 1 | 1 |
| 9 | 1 | 3 | 3-5 |
Could anyone help?
