Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
scan rows
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i fax a scan | Excel Discussion (Misc queries) | |||
scan to excel | Excel Discussion (Misc queries) | |||
virus scan | Setting up and Configuration of Excel | |||
Scan Forms | Excel Discussion (Misc queries) | |||
HOW CAN I SCAN DATA WITH COLUMNS AND ROWS DIRECTLY INTO SPREADSHE. | New Users to Excel |