Posted by Colin on December 21, 2001 4:33 AM
I posted this problem earlier this week but I don't think I stated my problem correctly.
I have already looked at the weekly tips on this subject and cannot find a solution.
My problem is that I have a huge file and I wish to get rid of some data and sum it in a column.
I have a list of data and when a department(each have a different number) has more than one account of the same number sum up the values in another column into one. The original rows that these accounts are in can be deleted.
111 543 $54,764
111 543 $45,765
111 543 $32,543
111 543 $133,072
The problem is that not all accounts need to be sumed just some specific ones.
Any help is appreciated.