Hi,
I hope you guys can help me. I have 6 columns spread out as following. The first is the truck nominator, the second the voyage in which the truck is, third the date, fourt the type of cargo its hauling, and fifth unit
I.E.
A B C D E
<table x:str="" style="border-collapse: collapse; width: 183pt;" width="245" border="0" cellpadding="0" cellspacing="0"><col style="width: 35pt;" span="2" width="47"> <col style="width: 44pt;" width="59"> <col style="width: 39pt;" width="52"> <col style="width: 30pt;" width="40"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 35pt;" x:str="VESSEL " width="47" height="17">Truck</td> <td class="xl24" style="border-left: medium none; width: 35pt;" width="47">VOY</td> <td class="xl24" style="border-left: medium none; width: 44pt;" width="59">DATE</td> <td class="xl25" style="border-left: medium none; width: 39pt;" width="52">CONT</td> <td class="xl24" style="border-left: medium none; width: 30pt;" width="40"> UNIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="border-top: medium none; height: 12.75pt;" height="17"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl28" style="border-top: medium none; border-left: medium none;">S2</td> <td class="xl29" style="border-top: medium none; border-left: medium none;" x:num="">11981</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt;" height="17"> </td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;">S4</td> <td class="xl33" style="border-top: medium none; border-left: medium none;" x:num="">22351</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt;" height="17">TOTAL</td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;">C4</td> <td class="xl33" style="border-top: medium none; border-left: medium none;" x:num="">20707</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl30" style="height: 13.5pt;" height="18"> </td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl43" style="border-left: medium none;"> </td> <td class="xl34" style="border-top: medium none; border-left: medium none;">L4</td> <td class="xl35" style="border-top: medium none; border-left: medium none;" x:num="">1</td> </tr> <tr style="height: 13.5pt;" height="18"> <td rowspan="4" class="xl46" style="border-bottom: 0.5pt solid black; height: 52.5pt;" height="70">BRZ</td> <td class="xl36" style="border-left: medium none;"> </td> <td rowspan="4" class="xl44" style="border-top: medium none;" x:num="38203">Aug-04</td> <td class="xl28" style="border-left: medium none;">S2</td> <td class="xl37" style="border-left: medium none;" x:num="">55</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl42" style="border-left: medium none; height: 12.75pt;" x:str="'00023" height="17">00023</td> <td class="xl32" style="border-top: medium none; border-left: medium none;">S4</td> <td class="xl39" style="border-top: medium none; border-left: medium none;" x:num="">172</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl38" style="border-left: medium none; height: 12.75pt;" height="17"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;">C4</td> <td class="xl39" style="border-top: medium none; border-left: medium none;" x:num="">134</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl38" style="border-left: medium none; height: 13.5pt;" height="18"> </td> <td class="xl34" style="border-top: medium none; border-left: medium none;">L4</td> <td class="xl40" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 13.5pt;" height="18"> <td rowspan="4" class="xl46" style="border-top: medium none; border-bottom: 0.5pt solid black; height: 52.5pt;" height="70">ELE</td> <td class="xl36" style="border-left: medium none;"> </td> <td rowspan="4" class="xl44" x:num="38203">Aug-04</td> <td class="xl28" style="border-left: medium none;">S2</td> <td class="xl37" style="border-left: medium none;" x:num="">88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl42" style="border-left: medium none; height: 12.75pt;" x:str="'0006" height="17">0006</td> <td class="xl32" style="border-top: medium none; border-left: medium none;">S4</td> <td class="xl39" style="border-top: medium none; border-left: medium none;" x:num="">211</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl38" style="border-left: medium none; height: 12.75pt;" height="17"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;">C4</td> <td class="xl39" style="border-top: medium none; border-left: medium none;" x:num="">135</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl38" style="border-left: medium none; height: 13.5pt;" height="18"> </td> <td class="xl34" style="border-top: medium none; border-left: medium none;">L4</td> <td class="xl41" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table>
Before, each row had and individual date so my array formula could count each type of cargo per voyage. I though that by merging for rows the formula would pull the information but it only recognizes cargo for S2,
is there any way I could make another rows pull out info from the date without having to copy the date to each type of cargo ??
I hope you guys can help me. I have 6 columns spread out as following. The first is the truck nominator, the second the voyage in which the truck is, third the date, fourt the type of cargo its hauling, and fifth unit
I.E.
A B C D E
<table x:str="" style="border-collapse: collapse; width: 183pt;" width="245" border="0" cellpadding="0" cellspacing="0"><col style="width: 35pt;" span="2" width="47"> <col style="width: 44pt;" width="59"> <col style="width: 39pt;" width="52"> <col style="width: 30pt;" width="40"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 35pt;" x:str="VESSEL " width="47" height="17">Truck</td> <td class="xl24" style="border-left: medium none; width: 35pt;" width="47">VOY</td> <td class="xl24" style="border-left: medium none; width: 44pt;" width="59">DATE</td> <td class="xl25" style="border-left: medium none; width: 39pt;" width="52">CONT</td> <td class="xl24" style="border-left: medium none; width: 30pt;" width="40"> UNIT</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="border-top: medium none; height: 12.75pt;" height="17"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl27" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl28" style="border-top: medium none; border-left: medium none;">S2</td> <td class="xl29" style="border-top: medium none; border-left: medium none;" x:num="">11981</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt;" height="17"> </td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;">S4</td> <td class="xl33" style="border-top: medium none; border-left: medium none;" x:num="">22351</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt;" height="17">TOTAL</td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;">C4</td> <td class="xl33" style="border-top: medium none; border-left: medium none;" x:num="">20707</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl30" style="height: 13.5pt;" height="18"> </td> <td class="xl31" style="border-left: medium none;"> </td> <td class="xl43" style="border-left: medium none;"> </td> <td class="xl34" style="border-top: medium none; border-left: medium none;">L4</td> <td class="xl35" style="border-top: medium none; border-left: medium none;" x:num="">1</td> </tr> <tr style="height: 13.5pt;" height="18"> <td rowspan="4" class="xl46" style="border-bottom: 0.5pt solid black; height: 52.5pt;" height="70">BRZ</td> <td class="xl36" style="border-left: medium none;"> </td> <td rowspan="4" class="xl44" style="border-top: medium none;" x:num="38203">Aug-04</td> <td class="xl28" style="border-left: medium none;">S2</td> <td class="xl37" style="border-left: medium none;" x:num="">55</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl42" style="border-left: medium none; height: 12.75pt;" x:str="'00023" height="17">00023</td> <td class="xl32" style="border-top: medium none; border-left: medium none;">S4</td> <td class="xl39" style="border-top: medium none; border-left: medium none;" x:num="">172</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl38" style="border-left: medium none; height: 12.75pt;" height="17"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;">C4</td> <td class="xl39" style="border-top: medium none; border-left: medium none;" x:num="">134</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl38" style="border-left: medium none; height: 13.5pt;" height="18"> </td> <td class="xl34" style="border-top: medium none; border-left: medium none;">L4</td> <td class="xl40" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 13.5pt;" height="18"> <td rowspan="4" class="xl46" style="border-top: medium none; border-bottom: 0.5pt solid black; height: 52.5pt;" height="70">ELE</td> <td class="xl36" style="border-left: medium none;"> </td> <td rowspan="4" class="xl44" x:num="38203">Aug-04</td> <td class="xl28" style="border-left: medium none;">S2</td> <td class="xl37" style="border-left: medium none;" x:num="">88</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl42" style="border-left: medium none; height: 12.75pt;" x:str="'0006" height="17">0006</td> <td class="xl32" style="border-top: medium none; border-left: medium none;">S4</td> <td class="xl39" style="border-top: medium none; border-left: medium none;" x:num="">211</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl38" style="border-left: medium none; height: 12.75pt;" height="17"> </td> <td class="xl32" style="border-top: medium none; border-left: medium none;">C4</td> <td class="xl39" style="border-top: medium none; border-left: medium none;" x:num="">135</td> </tr> <tr style="height: 13.5pt;" height="18"> <td class="xl38" style="border-left: medium none; height: 13.5pt;" height="18"> </td> <td class="xl34" style="border-top: medium none; border-left: medium none;">L4</td> <td class="xl41" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table>
Before, each row had and individual date so my array formula could count each type of cargo per voyage. I though that by merging for rows the formula would pull the information but it only recognizes cargo for S2,
is there any way I could make another rows pull out info from the date without having to copy the date to each type of cargo ??