G
Greg
I am a beginner so please go slow. Using excel 2000.
Is there any way to combine 2 rows into one.
Example Spreadsheet:
A1,A2,A3,A4,A5,..............BC3
1234567890,John Jones,1,2,55,............2222
1234567890,John Jones,1,2,535,............3333
The result I am looking for is;
1234567890,John Jones,2,4,590,..........3333
The logic is based on sort order.
If I have col A1 duplicated "1234567890" , I would like to add some fields
from the two rows and copy some fields from the second record. The second
record is defined as the record with the greater BC3 value used to sort the
table. In the example above it is the "3333" cell and value.
I could not find any instruction on how to do this or if it can be done. I
hope the only way is not manual I am dealing with a couple of hundred
instances that must be corrected.
Thank You
Greg
Is there any way to combine 2 rows into one.
Example Spreadsheet:
A1,A2,A3,A4,A5,..............BC3
1234567890,John Jones,1,2,55,............2222
1234567890,John Jones,1,2,535,............3333
The result I am looking for is;
1234567890,John Jones,2,4,590,..........3333
The logic is based on sort order.
If I have col A1 duplicated "1234567890" , I would like to add some fields
from the two rows and copy some fields from the second record. The second
record is defined as the record with the greater BC3 value used to sort the
table. In the example above it is the "3333" cell and value.
I could not find any instruction on how to do this or if it can be done. I
hope the only way is not manual I am dealing with a couple of hundred
instances that must be corrected.
Thank You
Greg