PDA

View Full Version : Copy Values



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

austenr
09-30-2005, 12:29 PM
Hi Jane. Could you post a sample file for everyone. It will be much easier for someone to help if the data is in a readable form. Most people post .zip files with any sensitive data removed.

Jane
09-30-2005, 01:18 PM
Copy Value
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!

TonyJollans
09-30-2005, 04:08 PM
If I understand correctly, then in what you call column E (but which is column F on the worksheet), in the cell on row 4 put:

=IF(VALUE(E4)=1,D4,"")

and copy it down to the end of your table

Jane
10-03-2005, 06:01 AM
Tony:

Thank you very much!

Jane