Merging names and amounts
Posted by Charles Chuateco on July 09, 2001 12:29 PM
Hello everyone. Compared to the wealth of information all of you possess, I am a novice with MS Excel. I currently use a database program that exports to excel the following information: organizations that our Foundation has funded, the dollar amounts and funding areas.
I spend time creating a spreadsheet that reports the total giving by area. Unfortunately, this program exports each dollar amount separately for a singular organization rather than combining that dollar amount into one figure. For example, if we funded USC ten times, it will list USC ten times with ten amounts in the next column rather than listing USC once with a total figure in the next column. So, the exported excel sheet is quite large, since we have funded some organizations many times.
I manually [=sum(X:Y)] calculate the totals for an organization funding area then change that amount into a value that I paste into the organizations first amount column. Then I go back and delete all of the other entries for the organization that I just totaled. Is there an easier way to solve this issue and have a formula that will both combine an organizations name and/or an all the amounts for an organization, in the entire spreadsheet? Merging cells does not merge dollar amounts, but rather keeps the top most cell. Any and all help would be truly appreciated. Thanks!