wrighty998
New Member
- Joined
- Jan 31, 2018
- Messages
- 35
Area: 02 - Surrey / Hants | apple | banana | 897596 | 0 | 13 | 0 | 0 | 0 | 0 | 4 | 5 | ||
Area: 02 - Surrey / Hants | apple | banana | 897959 | 0 | 0 | 0 | 2 | 3 | 0 | 4 | 6 | install | |
Area: 02 - Surrey / Hants | apple | banana | 897961 | 1 | 0 | 3 | 0 | 6 | 0 | 0 | 7 | ||
Area: 02 - Surrey / Hants | pear | apple | 896451 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 8 | install | |
Area: 02 - Surrey / Hants | pear | apple | 898202 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 9 | install | |
Area: 16 - Ireland | pear | apple | 895851 | 9 | 5 | 0 | 0 | 0 | 0 | 0 | 26 | install |
<colgroup><col style="mso-width-source:userset;mso-width-alt:7753;width:159pt" width="212"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:2377;width:49pt" width="65"> <col style="mso-width-source:userset;mso-width-alt:2304;width:47pt" width="63"> <col style="mso-width-source:userset;mso-width-alt:2669;width:55pt" width="73"> <col style="width:48pt" width="64" span="9"> </colgroup><tbody>
</tbody>
need to consolodate my data, if coloumn a,b,c match then consolodate numbers in row d into one cell, and sum row f,g,h,i,j,k,l,m and count n
thanks