Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Analyzing Bank Statements with Pivot Tables
I would like to perform analysis of a several years of bank statements. I
wish to be able to identify the main source of deposits and the main recipient of funds plus identify any trends that exist when monies come in as to who it then is sent to. I tried creating a pivot table but it only counts the number of credits and debits whereas I would like that plus be able to see dollar amounts. The trend thing really has me stumped. I don't think that is possible |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Analyzing Bank Statements with Pivot Tables
Change the function from Count to Sum. Right-Click on the column of numbers,
and it will give you an option to change. The specific instructions will depend on what version of Excel you are using. Regards, Fred. "Sleuth" wrote in message ... I would like to perform analysis of a several years of bank statements. I wish to be able to identify the main source of deposits and the main recipient of funds plus identify any trends that exist when monies come in as to who it then is sent to. I tried creating a pivot table but it only counts the number of credits and debits whereas I would like that plus be able to see dollar amounts. The trend thing really has me stumped. I don't think that is possible |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quarterly Statements in Pivot Tables | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot tables, IF statements, vlookups? | Excel Worksheet Functions | |||
how do I download barclays bank statements into excel | Excel Discussion (Misc queries) | |||
How do I reconcile bank statements? | Excel Worksheet Functions |