Hello,
I need to fill in a table by matching the vertical number in Column J with the horizontal number in Row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of N4 because both the vertical and horizontal numbers are 31494. Table looks like this:
DFW
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I need to fill in a table by matching the vertical number in Column J with the horizontal number in Row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of N4 because both the vertical and horizontal numbers are 31494. Table looks like this:
DFW
I | J | K | L | M | N | O | P | Q | |
1 | YEAR ROUND | ||||||||
2 | Item Names | ITEM | 90 Days | DF 60 MINUTE IPA 12/19.2 CAN | DF 60 MINUTE IPA 2/12/12 CAN | DF 60 MINUTE IPA 4/6/12NR | DF 90 MINUTE IPA HD 6/4/12NR | DF BURTON 6/4/12NR | DF FLESH AND BLOOD 4/6/12 CAN |
3 | Total | 40587 | 39941 | 31494 | 31502 | 31506 | 40022 | ||
4 | DF 60 MINUTE IPA 4/6/12NR | 31494 | 1 | 1 | |||||
5 | DF 60 MINUTE IPA 2/12/12 CAN | 39941 | 1 | ||||||
6 | DF SEAQUENCH ALE 4/6/12 CAN | 40023 | 1 | ||||||
7 | DF 90 MINUTE IPA HD 6/4/12NR | 31502 | 1 | ||||||
8 | DF INDIAN BROWN 4/6/12NR | 31496 | 1 | ||||||
9 | DF ROMANTIC CHEMISTRY 4/6/12 NR | 40718 | 1 | ||||||
10 | DF FESTINA PECHE 6/4/12NR | 31508 | 1 | ||||||
11 | DF 90 MINUTE IPA HD 6/4/12NR | 31502 | 1 | ||||||
12 | DF 90 MINUTE IPA HD 6/4/12NR | 31502 | 1 | ||||||
13 | DF NAMASTE 4/6/12NR | 31498 | 1 | ||||||
14 | DF SEAQUENCH ALE 4/6/12 CAN | 40023 | 1 | ||||||
15 | DF 60 MINUTE IPA 4/6/12NR | 31494 | 1 | ||||||
16 | DF 90 MINUTE IPA HD 6/4/12NR | 31502 | 1 | ||||||
17 | DF BEER TO DRINK MUSIC 4/6/12NR | 40369 | 1 | ||||||
18 | DF FLESH AND BLOOD 4/6/12 CAN | 40022 | 1 | ||||||
19 | DF SAISON DU BUFF 6/4/12 NR | 40083 | 1 | ||||||
20 | DF 120 MINUTE IPA 24/12NR | 31558 | 1 | ||||||
21 | DF MIDAS TOUCH 6/4/12NR | 31512 | 1 | ||||||
22 | DF ROMANTIC CHEMISTRY 4/6/12 NR | 40718 | 1 | ||||||
23 | DF INDIAN BROWN 4/6/12NR | 31496 | 1 | ||||||
24 | DF BURTON 6/4/12NR | 31506 | 1 | ||||||
25 | DF PALO SANTO 6/4/12NR | 31516 | 1 | ||||||
26 | DF LUPU-LUAU IPA 4/6/12 NR | 40909 | 1 | ||||||
27 | DF 60 MINUTE IPA 12/19.2 CAN | 40587 | 1 |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4