Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default match debits with credits

In my previous posts I was asking about counting unique invoice
numbers and Purchase Order numbers (PO's). Well, now I have a new
problem. I have to go through and evaluate the invoice numbers and
po's and eliminate any matching debits and credits from my count. This
may or may not affect including an invoice and po in my count. Many
invoices can be included on one po. What type of formula do I use to
match the debits and credits of an invoice number?

MILTENYI BIOTEC INC 16-Aug-07 PO 0721868 778184 $455.00
MILTENYI BIOTEC INC 16-Aug-07 PO 0721868 778184 ($492.00)
MILTENYI BIOTEC INC 16-Aug-07 PO 0721868 778184 $455.00
MILTENYI BIOTEC INC 16-Aug-07 PO 0721868 778184 $492.00
MILTENYI BIOTEC INC 16-Aug-07 PO 0721868 $37.00
MILTENYI BIOTEC INC 16-Aug-07 PO 0721868 778184 ($455.00)

MILTENYI BIOTEC INC 16-Aug-07 PO 0721963 777976 ($550.00)
MILTENYI BIOTEC INC 16-Aug-07 PO 0721963 $37.00
MILTENYI BIOTEC INC 16-Aug-07 PO 0721963 777976 $500.00
MILTENYI BIOTEC INC 16-Aug-07 PO 0721963 777976 $550.00
MILTENYI BIOTEC INC 21-Aug-07 PO 0722270 $37.00
MILTENYI BIOTEC INC 21-Aug-07 PO 0722270 778660 $520.00
MILTENYI BIOTEC INC 21-Aug-07 PO 0722271 $62.00
MILTENYI BIOTEC INC 21-Aug-07 PO 0722271 779439 $530.00
Reply
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
How do I change credits to debits in Excel cindy Excel Discussion (Misc queries) 4 April 17th 23 06:59 PM
Using Sumif with debits & credits Carol@Bell Excel Discussion (Misc queries) 3 June 14th 07 11:38 PM
vertical lines between credits and debits Carolyn New Users to Excel 1 March 28th 06 05:23 AM
debits and credits in one column childothe1980s Excel Programming 2 February 2nd 06 04:18 PM
Increment array for debits and credits MarcB[_2_] Excel Programming 0 July 14th 04 07:03 AM


All times are GMT +1. The time now is 04:46 AM.

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

About Us

"It's about Microsoft Excel"