| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting Banking Info to Excel - Debits and Credits
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. -- HTH... Jim Thomlinson "Tim Childs" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting Banking Info to Excel - Debits and Credits
Jim
thanks for this Tim "Jim Thomlinson" wrote in message ... 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. -- HTH... Jim Thomlinson "Tim Childs" wrote: 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 search but did not find anything useful Thanks Tim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting Banking Info to Excel - Debits and Credits
I suppose you could also use SumIf but I much prefer the sumproduct...
-- HTH... Jim Thomlinson "Tim Childs" wrote: Jim thanks for this Tim "Jim Thomlinson" wrote in message ... 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. -- HTH... Jim Thomlinson "Tim Childs" wrote: 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 search but did not find anything useful Thanks Tim |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting Banking Info to Excel - Debits and Credits
Why. For anything but toy problems Sumproduct/array formulas become
agonizingly slow. -- Regards, Tom Ogilvy "Jim Thomlinson" wrote in message ... I suppose you could also use SumIf but I much prefer the sumproduct... -- HTH... Jim Thomlinson "Tim Childs" wrote: Jim thanks for this Tim "Jim Thomlinson" wrote in message ... 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. -- HTH... Jim Thomlinson "Tim Childs" wrote: 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 search but did not find anything useful Thanks Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change credits to debits in Excel | Excel Discussion (Misc queries) | |||
| Using Sumif with debits & credits | Excel Discussion (Misc queries) | |||
| vertical lines between credits and debits | New Users to Excel | |||
| debits and credits in one column | Excel Programming | |||
| formula for debits and credits in EXCEL spreadsheet | Excel Worksheet Functions | |||
Linear Mode
