Generate list based on multiple criteria

  • Thread starter Thread starter allie357
  • Start date Start date
A

allie357

I am trying to count the number of unique invoice numbers. However, if
the invoice number has debits and credits I have to go through and
match the debits and the credits. If the total amount is zero, the
invoice number cannot be included in the original count. An example of
an invoice number that will need to be removed from my count is the
last one in the example list.

I was using this formula to help me find the matching credits and
debits but it does not seem to be meeting my needs:
=COUNTIF($H$1:$H1001,$A1&":"&$D1&":"&-$F1)>=COUNTIF($H$1:$H1,$H1)


Can someone help me find a formula that evaluates the invoice number
and all the amounts of that number to see if it adds up to zero. Then,
if it adds up to zero can it be added to a list? I am new at writing a
formula like this.

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/
colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0
align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid"
bgColor=#0c266b colSpan=7><TABLE width="100%" align=center
border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel -
Book1.xlsm</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-
FAMILY: caption" align=right>___Running: 12.0 : OS = Windows XP </
FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT:
#000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px"
bgColor=#d4d0c8 colSpan=7><TABLE width="100%" align=center border=0
VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000;
FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</
U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow
(<U>H</U>)elp <A onclick=show_popup(); href="#javascript:void(0)">
(<U>A</U>)bout</A></TD><TD vAlign=center align=right><FORM
name=formCb755237><INPUT onclick='window.clipboardData.setData
("Text",document.formFb078704.sltNb935705.value);' type=button
value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></
TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=7><TABLE
border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px"
align=middle bgColor=white><SELECT
onchange="document.formFb078704.txbFb426622.value =
document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION
value=-9433.84 selected>A1</OPTION></SELECT></TD><TD align=right
width="3%" bgColor=#d4d0c8><B>=</B></TD><TD align=left
bgColor=white><INPUT size=80 value="Vendor Name" name=txbFb426622></
TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT:
#000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT:
#000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle
width="2%"><BR></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-
FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>A</
CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu;
BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>B</CENTER></TD><TD
style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt
solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-
COLOR: #d4d0c8" align=middle><CENTER>C</CENTER></TD><TD style="BORDER-
RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-
SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR:
#d4d0c8" align=middle><CENTER>D</CENTER></TD><TD style="BORDER-RIGHT:
#000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt;
COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle><CENTER>E</CENTER></TD><TD style="BORDER-RIGHT: #000000
0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR:
black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle><CENTER>F</CENTER></TD></TR><TR><TD style="BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt
solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle width="2%"><CENTER>1</CENTER></TD><TD style="BORDER-
RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid;
COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY:
Calibri; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Vendor Name</
TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #c0c0c0; TEXT-ALIGN: center">Accounting Date</TD><TD
style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt
solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#c0c0c0; TEXT-ALIGN: center">Category</TD><TD style="BORDER-RIGHT:
#000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN:
center">Invoice Num</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN:
bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-
FAMILY: Calibri; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">PO
Number</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Amount</TD></TR><TR><TD
style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT:
#000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-
COLOR: #d4d0c8" align=middle width="2%"><CENTER>2</CENTER></TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; BORDER-LEFT: #c0c0c0 0.5pt solid; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">03-Jun-08</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: right">87709690</TD><TD style="BORDER-
RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom;
COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY:
Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"> </TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">
$4.84</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-
SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-
FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle
width="2%"><CENTER>3</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT:
#c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD style="BORDER-RIGHT:
#c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">03-Jun-08</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">87709690</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: left"> </TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: right">$0.72</TD></TR><TR><TD style="BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt
solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle width="2%"><CENTER>4</CENTER></TD><TD style="BORDER-
RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom;
BORDER-LEFT: #c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">03-
Jun-08</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE:
11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0
0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-
ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: right">87709690</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt
solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left"> </TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: right">$0.34</TD></TR><TR><TD
style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT:
#000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-
COLOR: #d4d0c8" align=middle width="2%"><CENTER>5</CENTER></TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; BORDER-LEFT: #c0c0c0 0.5pt solid; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">03-Jun-08</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: right">87709690</TD><TD style="BORDER-
RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom;
COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY:
Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"> </TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">
$0.99</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-
SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-
FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle
width="2%"><CENTER>6</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT:
#c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD style="BORDER-RIGHT:
#c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">03-Jun-08</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">87709690</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: left"> </TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: right">$1.52</TD></TR><TR><TD style="BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt
solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle width="2%"><CENTER>7</CENTER></TD><TD style="BORDER-
RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom;
BORDER-LEFT: #c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM:
#000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">03-
Jun-08</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE:
11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000
0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-
ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: right">87709690</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt
solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left"> </TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: right">$2.31</TD></TR><TR><TD
style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT:
#000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-
COLOR: #d4d0c8" align=middle width="2%"><CENTER>8</CENTER></TD><TD
style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000;
BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</
TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">02-Aug-07</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #000000
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: left">18245U</TD><TD style="BORDER-RIGHT:
#000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">766628</TD><TD
style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">
$9,433.84</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid;
FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000;
FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle
width="2%"><CENTER>9</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT:
#c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD style="BORDER-RIGHT:
#c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">02-Aug-07</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
left">18245U</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: right">766628</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt
solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: right">($9,433.84)</TD></TR><TR><TD style="BORDER-
RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid; BORDER-
LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #000000 0.5pt solid;
BACKGROUND-COLOR: #d4d0c8" colSpan=7><TABLE width="100%" align=left
VALIGN="TOP"><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-TOP: #808080 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid;
WIDTH: 120pt; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR:
#ffffff" align=left><U>Sheet2</U></TD><TD> </TD></TR></TBODY></TABLE></
TD></TR></TBODY></TABLE><BR><FONT color=#339966 size=1>[HtmlMaker
2.42] </FONT><FONT color=#339966 size=1>To see the formula in the
cells just click on the cells hyperlink or click the Name box</
FONT><BR><FONT color=red size=1>PLEASE DO NOT QUOTE THIS TABLE IMAGE
ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</FONT></CENTER>
 
Hai,

Could you please let us know more information about your problem, like where
(in which column) the invoice #, debit $, credit $ are listed and where do
you want the result to be displayed?

Assuming Invoice # in A column, Debit & Credit Amounts in B Column from 2nd
row to 1000 rows, I found the below formula filtering the unique invoice
numbers (whichever do not have a net value of zero) listed in column C.

=IF(SUMIF($A$2:$A$1000,A2,$B$2:$B$1000)=0,"",IF(COUNTIF($C$1:C1,A2)>=1,"",A2))

:)

allie357 said:
I am trying to count the number of unique invoice numbers. However, if
the invoice number has debits and credits I have to go through and
match the debits and the credits. If the total amount is zero, the
invoice number cannot be included in the original count. An example of
an invoice number that will need to be removed from my count is the
last one in the example list.

I was using this formula to help me find the matching credits and
debits but it does not seem to be meeting my needs:
=COUNTIF($H$1:$H1001,$A1&":"&$D1&":"&-$F1)>=COUNTIF($H$1:$H1,$H1)


Can someone help me find a formula that evaluates the invoice number
and all the amounts of that number to see if it adds up to zero. Then,
if it adds up to zero can it be added to a list? I am new at writing a
formula like this.

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/
colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0
align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid"
bgColor=#0c266b colSpan=7><TABLE width="100%" align=center
border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel -
Book1.xlsm</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-
FAMILY: caption" align=right>___Running: 12.0 : OS = Windows XP </
FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT:
#000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px"
bgColor=#d4d0c8 colSpan=7><TABLE width="100%" align=center border=0
VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000;
FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</
U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow
(<U>H</U>)elp <A onclick=show_popup(); href="#javascript:void(0)">
(<U>A</U>)bout</A></TD><TD vAlign=center align=right><FORM
name=formCb755237><INPUT onclick='window.clipboardData.setData
("Text",document.formFb078704.sltNb935705.value);' type=button
value="Copy Formula" name=btCb873980></FORM></TD></TR></TBODY></
TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=7><TABLE
border=0><TBODY><TR><FORM name=formFb078704><TD style="WIDTH: 60px"
align=middle bgColor=white><SELECT
onchange="document.formFb078704.txbFb426622.value =
document.formFb078704.sltNb935705.value" name=sltNb935705><OPTION
value=-9433.84 selected>A1</OPTION></SELECT></TD><TD align=right
width="3%" bgColor=#d4d0c8><B>=</B></TD><TD align=left
bgColor=white><INPUT size=80 value="Vendor Name" name=txbFb426622></
TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT:
#000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT:
#000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle
width="2%"><BR></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-
FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>A</
CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu;
BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>B</CENTER></TD><TD
style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt
solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-
COLOR: #d4d0c8" align=middle><CENTER>C</CENTER></TD><TD style="BORDER-
RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-
SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR:
#d4d0c8" align=middle><CENTER>D</CENTER></TD><TD style="BORDER-RIGHT:
#000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt;
COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle><CENTER>E</CENTER></TD><TD style="BORDER-RIGHT: #000000
0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR:
black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle><CENTER>F</CENTER></TD></TR><TR><TD style="BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt
solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle width="2%"><CENTER>1</CENTER></TD><TD style="BORDER-
RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid;
COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY:
Calibri; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Vendor Name</
TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #c0c0c0; TEXT-ALIGN: center">Accounting Date</TD><TD
style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt
solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#c0c0c0; TEXT-ALIGN: center">Category</TD><TD style="BORDER-RIGHT:
#000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN:
center">Invoice Num</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN:
bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-
FAMILY: Calibri; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">PO
Number</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center">Amount</TD></TR><TR><TD
style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT:
#000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-
COLOR: #d4d0c8" align=middle width="2%"><CENTER>2</CENTER></TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; BORDER-LEFT: #c0c0c0 0.5pt solid; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">03-Jun-08</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: right">87709690</TD><TD style="BORDER-
RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom;
COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY:
Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"> </TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">
$4.84</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-
SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-
FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle
width="2%"><CENTER>3</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT:
#c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD style="BORDER-RIGHT:
#c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">03-Jun-08</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">87709690</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: left"> </TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: right">$0.72</TD></TR><TR><TD style="BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt
solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle width="2%"><CENTER>4</CENTER></TD><TD style="BORDER-
RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom;
BORDER-LEFT: #c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">03-
Jun-08</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE:
11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0
0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-
ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: right">87709690</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt
solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left"> </TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: right">$0.34</TD></TR><TR><TD
style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT:
#000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-
COLOR: #d4d0c8" align=middle width="2%"><CENTER>5</CENTER></TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; BORDER-LEFT: #c0c0c0 0.5pt solid; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">03-Jun-08</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: right">87709690</TD><TD style="BORDER-
RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom;
COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY:
Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"> </TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">
$0.99</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-
SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-
FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle
width="2%"><CENTER>6</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT:
#c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD style="BORDER-RIGHT:
#c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">03-Jun-08</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">87709690</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: left"> </TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: right">$1.52</TD></TR><TR><TD style="BORDER-TOP:
#000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt
solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8"
align=middle width="2%"><CENTER>7</CENTER></TD><TD style="BORDER-
RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom;
BORDER-LEFT: #c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM:
#000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">03-
Jun-08</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE:
11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000
0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-
ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: right">87709690</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt
solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left"> </TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: right">$2.31</TD></TR><TR><TD
style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT:
#000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-
COLOR: #d4d0c8" align=middle width="2%"><CENTER>8</CENTER></TD><TD
style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000;
BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: left">CORPORATE EXPRESS A BUHRMANN CO</
TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
right">02-Aug-07</TD><TD style="BORDER-RIGHT: #000000 0.5pt solid;
FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: left">PO</TD><TD style="BORDER-RIGHT: #000000
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000;
BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-
COLOR: #ffffff; TEXT-ALIGN: left">18245U</TD><TD style="BORDER-RIGHT:
#000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #000000 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">766628</TD><TD
style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #000000 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">
$9,433.84</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid;
FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000;
FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle
width="2%"><CENTER>9</CENTER></TD><TD style="BORDER-RIGHT: #c0c0c0
0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; BORDER-LEFT:
#c0c0c0 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
left">CORPORATE EXPRESS A BUHRMANN CO</TD><TD style="BORDER-RIGHT:
#c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR:
#000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri;
BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">02-Aug-07</TD><TD
style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt; VERTICAL-
ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt solid;
FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PO</
TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-SIZE: 11pt;
VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #c0c0c0 0.5pt
solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN:
left">18245U</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt solid; FONT-
SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM:
#c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffffff;
TEXT-ALIGN: right">766628</TD><TD style="BORDER-RIGHT: #c0c0c0 0.5pt
solid; FONT-SIZE: 11pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-
BOTTOM: #c0c0c0 0.5pt solid; FONT-FAMILY: Calibri; BACKGROUND-COLOR:
#ffffff; TEXT-ALIGN: right">($9,433.84)</TD></TR><TR><TD style="BORDER-
RIGHT: #000000 0.5pt solid; BORDER-TOP: #808080 0.5pt solid; BORDER-
LEFT: #000000 0.5pt solid; BORDER-BOTTOM: #000000 0.5pt solid;
BACKGROUND-COLOR: #d4d0c8" colSpan=7><TABLE width="100%" align=left
VALIGN="TOP"><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid;
BORDER-TOP: #808080 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid;
WIDTH: 120pt; BORDER-BOTTOM: #000000 0.5pt solid; BACKGROUND-COLOR:
#ffffff" align=left><U>Sheet2</U></TD><TD> </TD></TR></TBODY></TABLE></
TD></TR></TBODY></TABLE><BR><FONT color=#339966 size=1>[HtmlMaker
2.42] </FONT><FONT color=#339966 size=1>To see the formula in the
cells just click on the cells hyperlink or click the Name box</
FONT><BR><FONT color=red size=1>PLEASE DO NOT QUOTE THIS TABLE IMAGE
ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</FONT></CENTER>
Click to expand...
 
Back
Top