Jane
09-30-2005, 12:19 PM
I have a Excel proble as below and hope that someone could help me.
I have a spreadsheet as below with more than 30 pages. How to use formula automaticlly to copy value in column C to column E, according to the number 1 in column D?
The new spreadsheet should be like table B.
Thanks!
Table A
ABCDE1INVOICEPOAMOUNTSERValue2 42733589963006447.94 1 3 42733589963006447.94 2 4 42733601962174447.94 1 5 42733601962174447.94 2 6 42734006962174447.94 1 7 42734006962174447.94 2 8 42734107959125447.94 1 9 42734107959125447.94 2 10 42734209959125895.87 1 11 42734209959125895.87 2 12 42734209959125895.87 3 13 42734310963006447.94 1 14 42734310963006447.94 2 15 16
Table B
ABCDE1INVOICEPOAMOUNTSERValue2 42733589963006447.94 1447.943 42733589963006447.94 2 4 42733601962174447.94 1447.945 42733601962174447.94 2 6 42734006962174447.94 1447.947 42734006962174447.94 2 8 42734107959125447.94 1447.949 42734107959125447.94 2 10 42734209959125895.87 1895.8711 42734209959125895.87 2 12 42734209959125895.87 3 13 42734310963006447.94 1447.9414 42734310963006447.94 2 15 42734310963006447.94 3 16 42734310963006447.94 4 17 18 Total Value3135.57
I have a spreadsheet as below with more than 30 pages. How to use formula automaticlly to copy value in column C to column E, according to the number 1 in column D?
The new spreadsheet should be like table B.
Thanks!
Table A
ABCDE1INVOICEPOAMOUNTSERValue2 42733589963006447.94 1 3 42733589963006447.94 2 4 42733601962174447.94 1 5 42733601962174447.94 2 6 42734006962174447.94 1 7 42734006962174447.94 2 8 42734107959125447.94 1 9 42734107959125447.94 2 10 42734209959125895.87 1 11 42734209959125895.87 2 12 42734209959125895.87 3 13 42734310963006447.94 1 14 42734310963006447.94 2 15 16
Table B
ABCDE1INVOICEPOAMOUNTSERValue2 42733589963006447.94 1447.943 42733589963006447.94 2 4 42733601962174447.94 1447.945 42733601962174447.94 2 6 42734006962174447.94 1447.947 42734006962174447.94 2 8 42734107959125447.94 1447.949 42734107959125447.94 2 10 42734209959125895.87 1895.8711 42734209959125895.87 2 12 42734209959125895.87 3 13 42734310963006447.94 1447.9414 42734310963006447.94 2 15 42734310963006447.94 3 16 42734310963006447.94 4 17 18 Total Value3135.57