Need to Combine Withdraws and Deposits to find Remainder for Hundreds of Users

[SirSavary]

I am attempting to use Excel 2010 to solve a dire problem of mine. I have some tables that I exported from a MySQL database; one is a table of accounts and the other is a table of transactions. What I need is to loop over each account (using the account ID, not the name on the account) and then combine all the transactions for that account to find what the remaining balance on the account is. This data could then be exported to somewhere else (I believe Excel can do this, correct me if I'm wrong) so that it can be looked over easily. I have roughly 500 users and over 350,000 transactions so this is pretty much impossible to do without some fancy logic.

I tried using the 'filter' tool in Excel which sped up the process, but I still had to do a lot of work manually. In the event that what I want in the first paragraph is not possible, I suppose I could go back to using filters. It would be much easier and faster however if I knew how simply change the filters and then look at formulas I have off to the side. I cannot figure out how to get A1 through the last A record (I'd always end up with A100, A300, etc). This is needed because each account has a different number of transactions.

I do not need a 100% complete solution but rather some pointers in the right direction. If any more information is needed I can supply it, thank you

[etaf]

a pivot table may work - just depends on how the transactions are recorded
a deposit positive number and a withdrawal a negative number , then it will work
if both a positive , how do you identify the difference between a deposit or a withdrawal

can you post a sample of the spreadsheet , without personal information, as this is a public forum

[SirSavary]

Here is a screenshot of the first 25 transactions: http://gyazo.com/b0b94f5c4a0b6bc054532deace86372d

Column A is the Transaction ID, B is the Account ID, C is the transaction type, D is the address where the money is sent and E is the amount. Columns F, G, H, I and D are not needed for what I am doing. Transaction amounts are all positive, the transaction type just tells you if money is going in or out.

[etaf]

can you attach here, so its a spreadsheet and not a image
also include the titles of the columns

you can add a formula to change the fees to negative

then in the data table in a new column (transactions) use a if( c2="fee", E2*-1, e2)

now you can simply use a pivot table and sum the values by account and you will get the balance

as i say attach the spreadsheet sample here

[newdoverman]

Depending upon how the worksheets are set up, the problem could be as easy as this: