Skip to Content
0
Former Member
Apr 27, 2009 at 11:54 PM

A case of the monthly deposits

30 Views

Hi All,

I have an excel spreadsheet that currently lists all of my clients(by account number) and all of their deposits made to my bank for the past 2 years. However, the clients are listed everytime they made a deposit, so if you can imagine, I have in column A1 many duplicated account numbers, Column B1 the date of each deposit, and column C1 the deposit amount.

My goal is to use this dataset and create a report that lists only each account number once, and then lists all the months from Jan '07 to Dec '08 at the top, and then assign each month when the client made a deposit/deposits. So for example, here is account number 001's history in excel:

A1 B1 C1

001 11/07/07 $329

001 12/07/07 $360

001 12/13/07 $50

001 12/22/07 $600

001 4/01/08 $50

And I want CRXI to show:

Acct. # Nov '07 Dec '07 Jan '08 Feb '08 Mar '08 Apr '08

001 $329 $1010 $0 $0 $0 $50

Of course, as much automation as possible is ideal because I have over 13000 entries!

Thank You very much!

Frank