Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following is from a single text file that contains several
batches. Each batch is seperated by the Batch Delimiter. Each batch can have multiple 6 records (first field), but only one of all the other records (1,5,8,9). My Problem: The third field of the 6 record is totaled within each batch and that amount is inserted into position 4 of the 8 record and position 5 of the 9 record. On some batches this amount has been calculated incorrectly. How can I fix this programatically? The number of batches varies within each file and the number of 6 records varies within each batch. While the first batch is correct, the second batch has two 6 records and this amount is incorrect on the 8 and 9 records. 1 01 055555555 544444444 030730 5 200 BIGCO 3544444444 6 22 01111111 2 0033333333333 8 200 000001 0001111111 000000000000 9 000001 000001 00000001 0001111111 Batch Deliminiter 1 01 055555555 544444444 030730 5 200 BIGCO 3544444444 6 23 06666666 4 8888888888 6 23 05555555 4 8888888888 8 200 000001 0000000000 000000000000 9 000001 000001 00000001 0000000000 Batch Deliminiter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) |