[FONT="]I have the an excell sheet like the following example:
column ABCD
[/FONT] <table class="MsoNormalTable" style="width: 404pt; border-collapse: collapse;" width="539" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="padding: 0cm; width: 56pt; height: 12.75pt;" width="75"> [FONT="]1.023-101.0<o></o>[/FONT]
</td> <td style="padding: 0cm; width: 170pt; height: 12.75pt;" width="227"> [FONT="] CV 30/1 *EU<o></o>[/FONT]
</td> <td style="padding: 0cm; width: 48pt; height: 12.75pt;" width="64"> </td> <td style="padding: 0cm; width: 82pt; height: 12.75pt;" width="109"> </td> <td style="padding: 0cm; width: 48pt; height: 12.75pt;" width="64"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]1.024-104.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WTC 600 CD *EU<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]1.024-116.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WPC 100 CD<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]1.024-205.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WPC 100 FW-A<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]1.024-205.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WPC 100 FW-A<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]1.024-212.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="] WPC 600 MP-AM<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> <tr style="height: 12.75pt;"> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]1.024-212.0<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WTC 600 MP-AM<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"> </td> <td style="padding: 0cm; height: 12.75pt;"></td> </tr> </tbody></table> [FONT="]
There are totally about 800 rows like them. As you can see some cells in the first column match. So i need somehow for every matching cell in column A to sumthe column D. Maybe it's unachievable that i'm asking.
[/FONT][FONT="]Thank you for your help. I appreciate.[/FONT]
column ABCD
[/FONT] <table class="MsoNormalTable" style="width: 404pt; border-collapse: collapse;" width="539" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 12.75pt;"> <td style="padding: 0cm; width: 56pt; height: 12.75pt;" width="75"> [FONT="]1.023-101.0<o></o>[/FONT]
</td> <td style="padding: 0cm; width: 170pt; height: 12.75pt;" width="227"> [FONT="] CV 30/1 *EU<o></o>[/FONT]
</td> <td style="padding: 0cm; width: 48pt; height: 12.75pt;" width="64">
[FONT="]60<o></o>[/FONT]
[FONT="]7<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WTC 600 CD *EU<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">
[FONT="]2001<o></o>[/FONT]
[FONT="]5<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WPC 100 CD<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">
[FONT="]60<o></o>[/FONT]
[FONT="]1<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WPC 100 FW-A<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">
[FONT="]60<o></o>[/FONT]
[FONT="]1<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WPC 100 FW-A<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">
[FONT="]2001<o></o>[/FONT]
[FONT="]1<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="] WPC 600 MP-AM<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">
[FONT="]2001<o></o>[/FONT]
[FONT="]1<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;"> [FONT="]WTC 600 MP-AM<o></o>[/FONT]
</td> <td style="padding: 0cm; height: 12.75pt;">
[FONT="]2001<o></o>[/FONT]
[FONT="]1<o></o>[/FONT]
There are totally about 800 rows like them. As you can see some cells in the first column match. So i need somehow for every matching cell in column A to sumthe column D. Maybe it's unachievable that i'm asking.
[/FONT][FONT="]Thank you for your help. I appreciate.[/FONT]