finding the count and sum of a transaction done in a month among 50000 clients

**cvsuryam** · 03-23-2011, 08:22 AM

Hello dear all,
I am working in a private bank. I am working on a file which will have log of transactions done in a month. I have around 50000 different clients. I want to have answer for the following.
I need to identify 1) how many times a client has done transaction ,,like howman withdrawls, howmany deposits, howmany ATM withdraws etc among all 50 branches and 2) the sum of transactions of that client for each case like withdrawl , deposit etc
I want to use a macro in vb
please help in this
thanks
suryam

**Roger Govier** · 03-23-2011, 08:31 AM

Hi
The easiest way would be to use a Pivot Table.

If you post details of your data layout, with some "dummy" sample data, we can give you instructions on how to achieve it

**MarvinP** · 03-23-2011, 08:33 AM

Hi cvsuryam and welcome to the forum,

Your problem souunds like a very easy pivot table to me. Client in the Row, Transaction Type in the Col with count of transaction and sum of transaction in the summation area. No VBA needed.

A small sample of your worksheet would help. You could take the first 400 transactions, or just use a single bank and copy it to a worksheet. Then rename all the clients to other names. Then click on "Go Advanced" below the message area and then on the Paper Clip Icon above the message area to open the Attach a File Window.

finding the count and sum of a transaction done in a month among 50000 clients

LinkBack

Thread Tools

Rate This Thread

Display

finding the count and sum of a transaction done in a month among 50000 clients

Re: finding the count and sum of a transaction done in a month among 50000 clients

Re: finding the count and sum of a transaction done in a month among 50000 clients

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions