David Wale
New Member
- Joined
- Sep 17, 2012
- Messages
- 25
Excel 2016 (Windows) 32 bit
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I have created the tables, (on the left), and have filled in the tables, (on the right), with what I wish to see.
There are two parts to this problem:-
Part one - For example, take CHE table. (on the left), B12=1, C12, D12 and E12 are blank. So, in the, (right hand table), using the CHE, (right hand table), what I wish to see is, V12, W12, X12 and Y12=1. And like wise for 2,3,4,5,6,7 etc.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ARS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ARS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||||||||||
2 | ARS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ARS | 1 | 1 | 1 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 6 | 6 | 7 | 7 | |||||||||||||
3 | ARS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | ARS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | |
4 | ARS | 1 | 3 | 1 | 1 | 3 | 3 | 3 | ARS | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||||||||||||
5 | |||||||||||||||||||||||||||||||||||||||
6 | BLB | 1 | 1 | 1 | 1 | 1 | 1 | 1 | BLB | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||||||||||
7 | BLB | 1 | 2 | 3 | 4 | 5 | 6 | 7 | BLB | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 7 | 7 | ||||||||||||
8 | BLB | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | BLB | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | |
9 | BLB | 3 | 0 | 0 | 0 | 1 | 0 | 3 | BLB | 3 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 3 | 3 | ||||||||||||
10 | |||||||||||||||||||||||||||||||||||||||
11 | CHE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | CHE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||||||||||
12 | CHE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | CHE | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 6 | 6 | 6 | 7 | ||||||||||||
13 | CHE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | CHE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | |
14 | CHE | 1 | 1 | 0 | 1 | 3 | 3 | 0 | CHE | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | 0 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet6 (2)
Hello ForumI have created the tables, (on the left), and have filled in the tables, (on the right), with what I wish to see.
There are two parts to this problem:-
Part one - For example, take CHE table. (on the left), B12=1, C12, D12 and E12 are blank. So, in the, (right hand table), using the CHE, (right hand table), what I wish to see is, V12, W12, X12 and Y12=1. And like wise for 2,3,4,5,6,7 etc.
Part two - For example, take CHE table. (on the left), B14=1, C14, D14 and E14 are blank. So, in the, (right hand table), using the CHE, (right hand table), what I wish to see is, V14, W14, X14 and Y14=1. And like wise for 0,1,3 etc.
Thank you
David Wale
Thank you
David Wale