 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / February 2006Pasting Banking Info to Excel - Debits and Credits
Hi Moment of laziness? surely not. Has anyone written a short proc. to convert bank entries which are text ending with " Dr" and " Cr" into the numerical equivalent. I did do a Google search but did not find anything useful Thanks Tim I never bothered. You can get around it using either pivot tables or the SumProduct Formula... Here is a link to sumproduct. http://www.xldynamic.com/source/xld.SUMPRODUCT.html Using either of these two methods you can segregate the debits from the credits and get the totals that you want.  SignatureHTH... Jim Thomlinson > Hi > [quoted text clipped - 7 lines] > > Tim Jim thanks for this Tim > I never bothered. You can get around it using either pivot tables or the > SumProduct Formula... Here is a link to sumproduct. [quoted text clipped - 19 lines] > > > > Tim I suppose you could also use SumIf but I much prefer the sumproduct... SignatureHTH... Jim Thomlinson > Jim > [quoted text clipped - 26 lines] > > > > > > Tim Why. For anything but toy problems Sumproduct/array formulas become agonizingly slow. SignatureRegards, Tom Ogilvy > I suppose you could also use SumIf but I much prefer the sumproduct... > [quoted text clipped - 28 lines] > > > > > > > > Tim |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.