J
Jonh
hi,
i need to scan rows in these 3 columns where i found the
first cell (C3)in column c is the same in the the second
cell (C4) until it doesnt'changes then sum B3 with b4, b5
ecc. This is a kind a subtotal.
1-column a column b column c
2-Date Weight name
3-12/06/2003 182,00 RIMA SPA
4-12/06/2003 26,00 RIMA SPA
5-12/06/2003 182,00 RIMA SPA
6-12/06/2003 120,00 RIMA SPA
7-13/06/2003 62,20 RIMA SPA
8-13/06/2003 3,75 RIMA SPA
9-16/06/2003 0,60 RIMA SPA
10-16/06/2003 525,00 PERINI SPA
11-16/06/2003 242,50 RIMA SPA
12-17/06/2003 11,98 RIMA SPA
13-19/06/2003 0,30 RIMA SPA
14-19/06/2003 252,00 RIMA SPA
15-19/06/2003 128,60 RIMA SPA
16-19/06/2003 4,10 RIMA SPA
The effect will be so
12/06/2003 510 RIMA SPA
13/06/2003 65,95 RIMA SPA
16/06/2003 0,60 RIMA SPA
16/06/2003 525,00 PERINI SPA
16/06/2003 242,50 RIMA SPA
17/06/2003 11,98 RIMA SPA
19/06/2003 385 RIMA SPA
Thanks in advance.John
i need to scan rows in these 3 columns where i found the
first cell (C3)in column c is the same in the the second
cell (C4) until it doesnt'changes then sum B3 with b4, b5
ecc. This is a kind a subtotal.
1-column a column b column c
2-Date Weight name
3-12/06/2003 182,00 RIMA SPA
4-12/06/2003 26,00 RIMA SPA
5-12/06/2003 182,00 RIMA SPA
6-12/06/2003 120,00 RIMA SPA
7-13/06/2003 62,20 RIMA SPA
8-13/06/2003 3,75 RIMA SPA
9-16/06/2003 0,60 RIMA SPA
10-16/06/2003 525,00 PERINI SPA
11-16/06/2003 242,50 RIMA SPA
12-17/06/2003 11,98 RIMA SPA
13-19/06/2003 0,30 RIMA SPA
14-19/06/2003 252,00 RIMA SPA
15-19/06/2003 128,60 RIMA SPA
16-19/06/2003 4,10 RIMA SPA
The effect will be so
12/06/2003 510 RIMA SPA
13/06/2003 65,95 RIMA SPA
16/06/2003 0,60 RIMA SPA
16/06/2003 525,00 PERINI SPA
16/06/2003 242,50 RIMA SPA
17/06/2003 11,98 RIMA SPA
19/06/2003 385 RIMA SPA
Thanks in advance.John