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

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

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
Google
search but did not find anything useful

Thanks

Tim

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
Google
search but did not find anything useful

Thanks

Tim

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
Google
search but did not find anything useful

Thanks

Tim