LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quarterly Statements in Pivot Tables TB in DC Excel Discussion (Misc queries) 2 January 9th 09 11:26 PM
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 08:05 PM
Pivot tables, IF statements, vlookups? dannyrblock Excel Worksheet Functions 2 September 20th 07 09:40 PM
how do I download barclays bank statements into excel balbir Excel Discussion (Misc queries) 1 August 21st 06 09:42 PM
How do I reconcile bank statements? RONCPA Excel Worksheet Functions 2 September 12th 05 08:06 PM


All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"